PostgreSQL (64-bit) Download (Latest 2021) for Windows 10, 8, 7

PostgreSQL 64-bit is a powerful, open source objective relational database systemE Has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity and accuracy. Works on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, macOS, Solaris, Tru64) and Windows. PostgreSQL 64-bit is a powerful object-relational database management system! Download PostgreSQL Offline Installer Setup 64bit for PC!

It is fully ACID compatible, has full support for foreign keys, connections, views, activations and stored procedures (in many languages). Includes most SQL data types: 2008, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL and TIMESTAMP. It also supports storing binary large objects, including images, sounds, or videos. It has native programming interfaces for C / C ++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and excellent documentation (panel sizes can reach 32 TB).

PostgreSQL 2021 comes with many features designed to help developers create applications, administrators protect data integrity and create bug-tolerant environments that help you manage your data no matter how big or small the data set. In addition to being free and open source, the tool is extremely scalable. For example, you can define your own data types, create custom functions, and even write code from different programming languages ​​without repackaging your database!

The application tries to comply with the SQL standard where this compliance does not conflict with traditional features or could lead to poor architectural decisions. Many of the features required by the SQL template are supported, though sometimes with slightly different syntax or functionality. Over time, further moves towards compliance are expected. Since version 11 was released in October 2018, Postgre SQL 64bit has complied with at least 160 of the 179 mandatory features for SQL: 2011 Core compliance, and as of this writing, no relational database is fully compliant with it. the template.

Characteristics and main points

Data types

• Prototypes: Integer, Arithmetic, String, Boolean
• Structured: Date /, ra, Table, Range, UUID
• Document: JSON / JSONB, XML, Key-value (Hstore)
• Geometry: Point, Line, Circle, Polygon
• Customizations: Advanced, Customized Types

Data integrity

• UNIQUE, NO NULL
• Primary keys
• Foreign keys
• Exclusion restrictions
• Explicit locks, consulting locks

Synchronization, Performance

• Indexing: B-tree, Multicolumn, Expressions, Partial
• Advanced Indexing: GiST, SP-Gist, KNN Gist, GIN, BRIN, Coverage Indexes, Bloom Filters
• Sophisticated query programmer / optimizer, index-only scans, multi-column statistics
• Transactions, Insert transactions (via storage points)
• Multi-Version Concurrency Control (MVCC)
• Parallel reading queries and creating B-tree indexes
• Table division
• All levels of transaction isolation defined in the SQL standard, including Serializable
• Just-in-time (JIT) expression collection

Reliability, disaster recovery

• Progress Log (WAL)
• Copy: Asynchronous, Contemporary, Logic
• Point-in-time-recovery (PITR), active waiting
• Table spaces

Security

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

Extensibility

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

Internationalization, Text Search

• Support for international character sets, e.g. through ICU collections
• Full text search

Also available: Download PostgreSQL for Mac