We are pleased to announce the availability of the PostgreSQL Global Development Group apt repository of PostgreSQL packages for Debian and Ubuntu.
The repository itself is located at http://apt.postgresql.org/pub/repos/apt/, with instructions in the PostgreSQL wiki at https://wiki.postgresql.org/wiki/Apt. The FAQ list is at https://wiki.postgresql.org/wiki/Apt/FAQ.
The repository already includes the latest PostgreSQL versions released today.
People using the old "pgapt.debian.net" location of this repository should update their sources.list entries.
We aim at building PostgreSQL server packages as well as extensions and modules packages on several Debian/Ubuntu releases for all PostgreSQL versions supported.
Currently, we support
Packages for older PostgreSQL versions and older Debian distributions will continue to stay in the repository; updates for those will be provided on an ad-hoc basis.
To use the repository, do the following:
Import the repository key from http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc:
wget -O - http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | sudo apt-key add -
Edit /etc/apt/sources.list.d/pgdg.list. The distributions are called codename-pgdg. In the example, replace squeeze with the actual distribution you are using:
deb http://apt.postgresql.org/pub/repos/apt/ squeeze-pgdg main
Configure apt's package pinning to prefer the PGDG packages over the Debian ones in /etc/apt/preferences.d/pgdg.pref:
Package: * Pin: release o=apt.postgresql.org Pin-Priority: 500
Note: this will replace all your Debian/Ubuntu packages with available packages from the PGDG repository. If you do not want this, skip this step.
Update the package lists, and install the pgdg-keyring package to automatically get repository key updates:
apt-get update apt-get install pgdg-keyring
More information: https://wiki.postgresql.org/wiki/Apt
The repository key used has id ACCC4CF8 and fingerprint B97B 0AFC AA1A 47F0 44F2 44A0 7FCC 7D46 ACCC 4CF8. The key is signed by Christoph Berg's keys that are well connected in Debian's web of trust.
Work on setting up the archive was kindly supported by credativ, Redpill Linpro, 2ndQuadrant, and the European Union's Seventh Framework Programme. The build server is kindly hosted by DG-i. The archive is hosted on postgresql.org hardware.