PGDG apt repository for Debian/Ubuntu

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 [1], with instructions in the
PostgreSQL wiki at [2]. The FAQ list is at [3].

[1] http://apt.postgresql.org/pub/repos/apt/
[2] https://wiki.postgresql.org/wiki/Apt
[3] https://wiki.postgresql.org/wiki/Apt/FAQ

The repository already includes the latest PostgreSQL versions
released today.

== Project ==

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
* Debian 6.0 (squeeze), 7.0 (wheezy), and unstable (sid)
* Ubuntu 12.4 (precise), support for lucid is being worked on
* PostgreSQL 8.3, 8.4, 9.0, 9.1, 9.2
* Several server extensions such as Slony-I, various PL languages, and datatypes
* Applications like pgadmin3, pgbouncer, and pgpool-II

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.

== Quickstart ==

To use the repository, do the following:

Import the repository key from 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 (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

Update the package lists, and install the pgdg-keyring package:
apt-get update
apt-get install pgdg-keyring

More information: http://wiki.postgresql.org/wiki/Apt

== Repository Key ==

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.

== Acknowledgements ==

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.

Re: Karl O. Pinc 2012-12-07 <1354848245(dot)14162(dot)3(at)mofo>
> On 12/06/2012 01:11:28 PM, Christoph Berg wrote:
> > We are pleased to announce the availability of the PostgreSQL Global
> > Development Group apt repository of PostgreSQL packages for Debian
> > and
> > Ubuntu.
>
> I'm not sure who to write, so you're it.
>
> Awesome. Thanks very much.

Thanks :)

> FYI
> I would love to see postgis on the list of included extensions.
>
> (As much as I'd rather work on Debian) I await Ubuntu Lucid
> packages.

Postgis has been what people kept asking us since we started this, but
so far we were going for easier targets. It's definitely something we
want as well, we'll post on the pgsql-pkg-debian list and on the wiki
page when we have it included.

Same for Lucid, it's not really hard to get it ready, it was just more
involved than precise, so I skipped it, but the infrastructure is
there. I'd expect that to be ready over the next days/weeks.

Christoph
--
cb(at)df7cb(dot)de | http://www.df7cb.de/

Re: Wim Bertels 2012-12-07 <1354875947(dot)4134(dot)2(dot)camel(at)zwerfkat>
> Hallo Christoph,
>
> Great initiative,

Thanks.

> one question (probably for the FAQ)
>
> What about dist-upgrades?
> (having installed postgresql from apt.postgresql.org)

Right, we should cover that there.

The version numbers are designed such that dist-upgrades work, e.g.
you can upgrade from postgresql-9.2 in squeeze 9.2.2-1.pgdg60+1 to
9.2.2-1.pgdg70+1 in wheezy. I'll think of something for the FAQ,
thanks for the suggestion.

Christoph
--
cb(at)df7cb(dot)de | http://www.df7cb.de/