Peripheral Links
Linux downloads (Debian)
PostgreSQL is available in all Debian versions by default. However, the stable versions of Debians "snapshot" a specific version of PostgreSQL that is then supported throughout the lifetime of that Debian version. The PostgreSQL project also maintains an apt repository with all supported of PostgreSQL available.
Should packages not be available for your distribution, or there are issues with your package manager, there are graphical installers available.
Finally, most Linux systems make it easy to build from source.
Included in distribution
Debian includes PostgreSQL by default. To install PostgreSQL on Debian, use the apt-get (or other apt-driving) command:
apt-get install postgresql-9.1
The repository contains many different packages including third party addons. The most command and important packages are (substitute the version number as required):
- postgresql-client-9.1 - client libraries and client binaries
- postgresql-9.1 - core database server
- postgresql-contrib-9.1 - additional supplied modules
- libpq-dev - libraries and headers for C language frontend development
- postgresql-server-dev-9.1 - libraries and headers for C language backend development
- pgadmin3 - pgAdmin III graphical administration utility
PostgreSQL Apt Repository
If the version included in your version of Debian is not the one you want, you can use the PostgreSQL Apt Repository. This repository will integrate with your normal systems and patch management, and provide automatic updates for all supported versions of PostgreSQL throughout the support lifetime of PostgreSQL.
To use the apt repository, follow these steps:
- Import the repository signing key
wget -O - http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | sudo apt-key add - - Edit the file /etc/apt/sources.list.d/pgdg.list, and add a line
for the repository, substituting the proper "codename" for your release
deb http://apt.postgresql.org/pub/repos/apt/ squeeze-pgdg main - Configure apt's package pinning to prefer the PGDG packages over the standard ones in /etc/apt/preferences.d/pgdg.pref
Package: *
Pin: release o=apt.postgresql.org
Pin-Priority: 500 - Update the package lists, and install the pgdg-keyring package to automatically get repository key updates
sudo apt-get update
sudo apt-get install pgdg-keyring
For more information about the apt repository, including answers to frequent questions, please see the apt page on the wiki.
Debian backports
Newer versions of PostgreSQL for older versions of Debians are available in Debian backports. For information on how to enable and use the backports repository, please see the backports instructions page at Debian.
Once backports is enabled, you can install PostgreSQL the same way as with the builtin repositories.
Graphical installer
One click installers are available for 32 and 64 bit Linux distributions and include PostgreSQL, pgAdmin and the StackBuilder utility for installation of additional packages. The PostgreSQL 8.3 and 8.4 installers have been tested with a number of Linux distributions and should work on Ubuntu 6.06 and above, Fedora 6 and above, CentOS/RedHat Enterprise Linux 4 and above and others. The 9.0 and later installers have only been tested on more recent distributions.
Download the installer from EnterpriseDB for all supported versions.
Note: The one click installers do not integrate with platform-specific packaging systems.
Build from source
The source code can be found in the main file browser. Instructions for building from source can be found in the documentation.