Главная › Услуги › Postgresql скачать для windows 10 русская версия. Замечания по установке. Поддерживаемые операционные системы

Postgresql скачать для windows 10 русская версия. Замечания по установке. Поддерживаемые операционные системы

Select Version PostgreSQL 10.5.1 (32-bit) PostgreSQL 10.4.1 (32-bit) PostgreSQL 10.3.2 (32-bit) PostgreSQL 10.3 (32-bit) PostgreSQL 10.2 (32-bit) PostgreSQL 10.1 (32-bit) PostgreSQL 10.0 (32-bit) PostgreSQL 9.6.5 (32-bit) PostgreSQL 9.6.4 (32-bit) PostgreSQL 9.6.3 (32-bit) PostgreSQL 9.6.2 (32-bit) PostgreSQL 9.6.1 (32-bit) PostgreSQL 9.6.0 (32-bit) PostgreSQL 9.5.4 (32-bit) PostgreSQL 9.5.3 (32-bit) PostgreSQL 9.5.2 (32-bit) PostgreSQL 9.5.1 (32-bit) PostgreSQL 9.5.0 (32-bit) PostgreSQL 9.4.5 (32-bit) PostgreSQL 9.4.4 (32-bit) PostgreSQL 9.4.3 (32-bit) PostgreSQL 9.4.2 (32-bit) PostgreSQL 9.4.1 (32-bit) PostgreSQL 9.4.0 (32-bit) PostgreSQL 9.3.5 (32-bit) View more...

postgresql-10.5-1-windows.exe

PostgreSQL (32-bit) 2019 full offline installer setup for PC

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. PostgreSQL is a powerful object-relational database management system!

It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation (table sizes can go up to 32 TB).

PostgreSQL 2019 comes with many features aimed to help developers build applications, administrators to protect data integrity and build fault-tolerant environments, and help you manage your data no matter how big or small the dataset. In addition to being free and open source, PostgreSQL is highly extensible. For example, you can define your own data types, build out custom functions, even write code from different programming languages without recompiling your database!

PostgreSQL tries to conform with the SQL standard where such conformance does not contradict traditional features or could lead to poor architectural decisions. Many of the features required by the SQL standard are supported, though sometimes with slightly differing syntax or function. Further moves towards conformance can be expected over time. As of the version 11 release in October 2018, PostgreSQL conforms to at least 160 of the 179 mandatory features for SQL:2011 Core conformance, where as of this writing, no relational database meets full conformance with this standard.

PostgreSQL Features:

Data Types

Primitives: Integer, Numeric, String, Boolean
Structured: Date/Time, Array, Range, UUID
Document: JSON/JSONB, XML, Key-value (Hstore)
Geometry: Point, Line, Circle, Polygon
Customizations: Composite, Custom Types

Data Integrity

UNIQUE, NOT NULL
Primary Keys
Foreign Keys
Exclusion Constraints
Explicit Locks, Advisory Locks

Concurrency, Performance

Indexing: B-tree, Multicolumn, Expressions, Partial
Advanced Indexing: GiST, SP-Gist, KNN Gist, GIN, BRIN, Covering indexes, Bloom filters
Sophisticated query planner / optimizer, index-only scans, multicolumn statistics
Transactions, Nested Transactions (via savepoints)
Multi-Version concurrency Control (MVCC)
Parallelization of read queries and building B-tree indexes
Table partitioning
All transaction isolation levels defined in the SQL standard, including Serializable
Just-in-time (JIT) compilation of expressions

Reliability, Disaster Recovery

Write-ahead Logging (WAL)
Replication: Asynchronous, Synchronous, Logical
Point-in-time-recovery (PITR), active standbys
Tablespaces

Security

Authentication: GSSAPI, SSPI, LDAP, SCRAM-SHA-256, Certificate, and more
Robust access-control system
Column and row-level security

Extensibility

Stored functions and procedures
Procedural Languages: PL/PGSQL, Perl, Python (and many more)
Foreign data wrappers: connect to other databases or streams with a standard SQL interface
Many extensions that provide additional functionality, including PostGIS

Internationalisation, Text Search

Support for international character sets, e.g. through ICU collations
Full-text search

Postgres Professional has prepared the PostgreSQL distribution packages for Windows.

The 32 bit version requires Windows XP SP3 or newer, the 64 bit one requires Windows Vista 64bit or newer.

To install PostgreSQL on your computer please download one of the following files (Note that downloading any of them means your agreement with ):

PostgreSQL 11.2: 64bit , 32bit
PostgreSQL 10.7: 64bit , 32bit
PostgreSQL 9.6.12: x64 , x86
PostgreSQL 9.5.16: x64 , x86 ,
PostgreSQL 9.4.21: x64 , x86 ,
pgAdmin3 1.22.1: x86

For older Windows versions, like WinXP and Windows Server 2003 use the following links for 64- and 32-bit respectively:

PostgreSQL 9.6.12: x64 , x86
PostgreSQL 9.5.16: x64 , x86
PostgreSQL 9.4.21: x64 , x86

Specific features of Postgres Professional build are:

automatic server configuration parameters setup based on available RAM
non-latin messages encoding issue solved (at least for cyrillic)
additional shortcuts for server stop, start and restart.
critical bug fixes

Disclaimer

This software is provided AS IS, without expressed or implied warranty of any kind, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. In no event shall Postgres Professional or any contributors of this software be liable for any kind of damages, including, but not limited to, direct, indirect, incidental, special, exemplary, consequental, procurement of substitute goods or services, loss of use, data or profits, or business interruption.

License

Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs appear in all copies.

IN NO EVENT SHALL THE UNIVERSITY OF CALIFORNIA BE LIABLE TO ANY PARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION, EVEN IF THE UNIVERSITY OF CALIFORNIA HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

THE UNIVERSITY OF CALIFORNIA SPECIFICALLY DISCLAIMS ANY WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS ON AN "AS IS" BASIS, AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.

Installation notes

Supported Operation Systems

This PostgreSQL version can be installed only on Windows SP3 or newer. The 64 bit build requires the 64-bit Windows version .

Installation process

At the beginning of installation choose the components to install.

If the installation script detects a previously installed PostgreSQL server, it proposes to stop and upgrade it. If so, all the connections to the server would be broken. The detection of previously installed server is performed using the system registry, so it might not work for manual or nonstandard installations.

During the installation it is prompted for the executable files and PGDATA directories. If the PGDATA directory already contains data, it will be used without reinitialization, so the prevoius data and configuration files will be preserved. If it does not exists or is empty, the user is prompted for the port number, superuser name and password and other options. The most important memory options shared_buffers and work_mem will be guessed if available RAM is > 1Gb.

After installation the server is started and is ready for work without rebooting the computer.

Windows service account

The server is started using the special windows account "NT AUTHORITY\NetworkService". This can be changed later using the Windows administration software.

Shortcuts

The following shortcuts are created in Windows Start menu (if it exists in your Windows version):

SQL Shell (psql) - the main native administration and quering tool.
Reload Configuration - signal the server to reload configuration files. Please note that changing some of the configuration parameters require server restart.
Restart Server - stop and start the server with closing all active connections.
Stop Server - stop the server with closing all active connections.
Start Server - start the server.

If you have chosen to install pgAdmin, it will be also provided a shortcut.

Uninstallation

To uninstall the server use the Uninstall shortcut or Windows Control Panel. All connections are closed. Data is not removed. Reboot is not required.

Trademark Notices

Microsoft ® , Windows ® , Windows NT ® , Windows Server ® and Windows Vista TM are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.

Windows (All Versions)

postgresql-8.4.7-1-windows.exe

3107dc001264cba30c97fd73b487e722

PostgreSQL Features:

Data Types

Primitives: Integer, Numeric, String, Boolean
Structured: Date/Time, Array, Range, UUID
Document: JSON/JSONB, XML, Key-value (Hstore)
Geometry: Point, Line, Circle, Polygon
Customizations: Composite, Custom Types

Data Integrity

UNIQUE, NOT NULL
Primary Keys
Foreign Keys
Exclusion Constraints
Explicit Locks, Advisory Locks

Concurrency, Performance

Indexing: B-tree, Multicolumn, Expressions, Partial
Advanced Indexing: GiST, SP-Gist, KNN Gist, GIN, BRIN, Covering indexes, Bloom filters
Sophisticated query planner / optimizer, index-only scans, multicolumn statistics
Transactions, Nested Transactions (via savepoints)
Multi-Version concurrency Control (MVCC)
Parallelization of read queries and building B-tree indexes
Table partitioning
All transaction isolation levels defined in the SQL standard, including Serializable
Just-in-time (JIT) compilation of expressions

Reliability, Disaster Recovery

Write-ahead Logging (WAL)
Replication: Asynchronous, Synchronous, Logical
Point-in-time-recovery (PITR), active standbys
Tablespaces

Security

Authentication: GSSAPI, SSPI, LDAP, SCRAM-SHA-256, Certificate, and more
Robust access-control system
Column and row-level security

Extensibility

Stored functions and procedures
Procedural Languages: PL/PGSQL, Perl, Python (and many more)
Foreign data wrappers: connect to other databases or streams with a standard SQL interface
Many extensions that provide additional functionality, including PostGIS

Internationalisation, Text Search

Support for international character sets, e.g. through ICU collations
Full-text search

# Major enhancements include:
* Built-in replication based on log shipping. This advance consists of two features: Streaming Replication, allowing continuous archive (WAL) files to be streamed over a network connection to a standby server, and Hot Standby, allowing continuous archive standby servers to execute read-only queries. The net effect is to support a single master with multiple read-only slave servers.
* Easier database object permissions management. GRANT/REVOKE IN SCHEMA supports mass permissions changes on existing objects, while ALTER DEFAULT PRIVILEGES allows control of privileges for objects created in the future. Large objects (BLOBs) now support permissions management as well.
* Broadly enhanced stored procedure support. The DO statement supports ad-hoc or "anonymous" code blocks. Functions can now be called using named parameters. PL/pgSQL is now installed by default, and PL/Perl and PL/Python have been enhanced in several ways, including support for Python3.
* Full support for 64-bit Windows.
* More advanced reporting queries, including additional windowing options (PRECEDING and FOLLOWING) and the ability to control the order in which values are fed to aggregate functions.
* New trigger features, including SQL-standard-compliant per-column triggers and conditional trigger execution.
* Deferrable unique constraints. Mass updates to unique keys are now possible without trickery
* Exclusion constraints. These provide a generalized version of unique constraints, allowing enforcement of complex conditions.
* New and enhanced security features, including RADIUS authentication, LDAP authentication improvements, and a new contrib module passwordcheck for testing password strength.
* New high-performance implementation of the LISTEN/NOTIFY feature. Pending events are now stored in a memory-based queue rather than a table. Also, a "payload" string can be sent with each event, rather than transmitting just an event name as before.
* New implementation of VACUUM FULL. This command now rewrites the entire table and indexes, rather than moving individual rows to compact space. It is substantially faster in most cases, and no longer results in index bloat.
* New contrib module pg_upgrade to support in-place upgrades from 8.3 or 8.4 to 9.0.
* Multiple performance enhancements for specific types of queries, including elimination of unnecessary joins. This helps optimize some automatically-generated queries, such as those produced by object-relational mappers (ORMs).
* EXPLAIN enhancements. The output is now available in JSON, XML, or YAML format, and includes buffer utilization and other data not previously available.
* hstore improvements, including new functions and greater data capacity.