Peripheral Links
Header And Logo
Site Navigation
Downloads
PostgreSQL Core Distribution
The core of the PostgreSQL object-relational database management system is available in several source and binary formats. The full package includes:
- The core server with full documentation (html, man)
- Several command line tools (e.g. psql, pg_ctl, pg_dump, pg_restore)
- C library (libpq) and embedded C processor (ecpg)
- Several server-side procedural languages (e.g. plpgsql, pltcl, plperl)
- Several popular add-on packages (e.g. metaphone, tsearch2, pgcrypto)
You can download the software from a mirror using our File Browser. If you prefer, you can browse the download mirrors directly.
Other Software
There is much software available that is not bundled with PostgreSQL. The following list is by no means exhaustive, but offers a highlight of some of the more popular community developed packages. It should be noted that there are also many commercial packages available for PostgreSQL.
Graphical Clients
- pgAdmin III - Cross-platform administration tool
- PhpPgAdmin - Web-based PostgreSQL administration tool
Application Programming Interfaces
- DBD::Pg - Perl Driver
- JDBC - JDBC Driver
- libpqxx - C++ API
- Npgsql - .Net Data Provider
- ODBCng - ODBC Driver
- PgOleDb - OLE-DB Driver
- pgtclng - Next generation interface for TCL
- Pgtcl - Tcl binding library
- Pgin - Tcl interface to PostgreSQL written in Tcl
- psqlODBC - ODBC Driver
- PyGreSQL - Python interface for PostgreSQL
- psycopg - Another Python interface for PostgreSQL
- postgresql-sdbc - OpenOffice.org PostgreSQL Driver
Server-side Procedural Languages
- PL/Java - Java procedural language using in-process JNI-based integration
- PL/php - PHP-based procedural language
- PL/psm - ANSI SQL compliant language for stored procedures based on current plpgsql environment.
- pl/R - Procedural language based on the R statistical language
- pl-ruby - Ruby based procedural language
- PL/scheme - Schema based procedural language
- PL/sh - procedural language handler for PostgreSQL that allows you to write stored procedures in a shell of your choice.
Additional Functionality
- OpenFTS (Open Source Full Text Search Engine) - An advanced PostgreSQL-based search engine that provides online indexing of data and relevance ranking for database searching. Close integration with database allows use of metadata to restrict search results.
- PL/proxy - PostgreSQL partitioning system implemented as PL language.
- Slony1 - Master to multiple slave replication system with cascading and failover.
- PostGIS - Adds support for geographic objects to the PostgreSQL object-relational database.
Reporting
- TrafficObjects - Fetches data from remote databases (currently PostgreSQL and Oracle) and stores it internally in PostgreSQL. This data is then used to create real-time, streaming charts.
PostgreSQL Logos
- PostgreSQL Logos - Logos for use on your website
Other Software
- PgFoundry - Home for PostgreSQL related projects
- Commercial Products - Non-free PostgreSQL products
Other ways to get PostgreSQL
Many 3rd party distributors bundle PostgreSQL along with their software. For users of these systems, you may find it easier to install PostgreSQL using the custom package design for your distribution. It may also be worth investigating what additional PostgreSQL software is bundled for your system.
- Debian Apt - (stable|backports)
- BitRock LAPP Stack - Bundles Apache, PostgreSQL, PHP, Python, and supporting libraries.
- Cygwin - a Unix like environment for Win32 users.
- EnterpriseDB Postgres - Includes consistent cross-platform GUI installers that deliver the most commonly needed PostgreSQL components and add-ons.
- Fink - Open source package system for OSX users.
- MacPorts - Open source package system for OSX users.
- Mammoth - a business and developer complete PostgreSQL distribution.
- Portage - The Gentoo packaging system.
- Ports - The FreeBSD packaging system.
- Ubuntu Apt
- Yum - Packaging system for Fedora and other Red Hat flavored distributions.