Please Note: EDB no longer provides PostgreSQL installers for Linux, and users are encouraged to use the platform-native packages. For more information, please see this blog post on Platform Native EDB Packages for Linux Users.
PostgreSQL is the world’s most advanced open source database and the fourth most popular database. In development for more than 20 years, PostgreSQL is managed by a well-organized and highly principled and experienced open source community. It is an object-oriented database that is fully ACID compliant and highly extensible, enabling the community to add new features and capabilities as workload demands evolved.
Because of its extensibility, PostgreSQL offers a wide variety of built-in data types including JSON, XML, HSTORE (key-value), Geo-spatial (PostGIS), IPv6; flexible indexing, featuring composite indexes, GiST, SP- GiST, GIN; full Text Search, online index reorganization; background workers such as a managed process known as Mongress, which accepts MongoDB queries to interface with Postgres data; a contrib module interface: pgcrypto (data encryption), pg_trgm (find 'similar' data), HSTORE (schema-less data); and extensive SQL support.
PostgreSQL runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, macOS, Solaris), and Windows. It offers the following programming languages: PL/pgSQL, PL/SQL, Java, Python, Ruby, C/C+, PHP, Perl, Tcl, Scheme. Postgres also offers the following Library interfaces: OCI, libpq, JDBC, ODBC, .NET, Perl, Python, Ruby, C/C+, PHP, Lisp, Scheme, and Qt.