Download PostgreSQL Download (2023 Latest) Free

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

It is fully ACID compliant, has full support for foreign keys, joins, views, triggers and stored procedures (multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports the storage of blobs, including images, sounds, or videos. It has its own APIs for C/C++, Java

, .Net, Pearl, python, RubyTcl, ODBC, and more, as well as exceptional documentation (tables can be up to 32 TB in size).

Postgres SQL 2023 comes with many features designed to help developers build applications and administrators to protect data integrity and build fault-tolerant environments and help you manage your data, no matter how big or small the dataset is. In addition to being free and open source, this tool is highly extensible. For example, you can define your own data types, create your own functions, and even write code in different programming languages ​​without recompiling the database!

An application attempts to conform to the SQL standard, unless such conformance conflicts with traditional functionality and cannot lead to incorrect architectural decisions. Many of the features required by the SQL standard are supported, although sometimes with slightly different syntax or features. Over time, further steps towards compliance can be expected. As of version 11, released in October 2018, 64-bit Postgre SQL meets at least 160 of the 179 required features for SQL: 2011 Core compliance, while at the time of this writing, no relational database fully complies with this standard. measure.

Features and 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
• Settings: Compound, 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, coverage indexes, bloom filters
• Sophisticated query planner/optimizer, index-only scan, multi-column statistics
• Transactions, nested transactions (via savepoints)
• Multiversion Concurrency Control (MVCC)
• Parallelizing read queries and building B-tree indexes
• Table split
• 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 reserves
• Tablespaces

Safety

• Authentication: GSSAPI, SSPI, LDAP, SCRAM-SHA-256, certificate, etc.
• Reliable access control system
• Security at the column and row level

Expandability

• Stored Functions and Procedures
• Procedural languages: PL/PGSQL, Perl, Python (and many more)
• External Data Wrappers: Connect to other databases or streams with a standard SQL interface.
• Many extensions providing additional functionality, including PostGIS

Internationalization, text search

• Support for international character sets, eg via ICU collation.
• Full text search

Also available: Download PostgreSQL for Mac