• Text Size: Normal / Large
• Donate
• Contact

Section Navigation

• Downloads
• File Browser
• Community Software
  • pgFoundry
  • gborg
• Commercial Products

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
• ODBC - ODBC Driver
• PgOleDb - OLE-DB Driver
• pgtclng - Next generation interface for TCL
• Pgtcl - Tcl binding library
• Pgin - A Tcl interface to PostgreSQL written in Tcl
• PyGreSQL - Python interface for PostgreSQL
• psycopg - Another Python interface for PostgreSQL

Server-side Procedural Languages

• PL/Java - Java procedural language using in-process JNI-based integration
• PL-J - Java procedural language using one jvm per database
• plPHP - PHP-based procedural language
• plR - Procedural language based on the R statistical language
• pl-ruby - Ruby based procedural language

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.
• Slony1 - Master to multiple slave replication system with cascading and failover.
• PostGIS - Adds support for geographic objects to the PostgreSQL object-relational database.

PostgreSQL Logos

• PostgreSQL Logos - Logos for use on your website

Other Software

• PgFoundry - Home for PostgreSQL related projects
• Gborg - Previous 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.
• Fink - 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.