Apt

From PostgreSQL wiki

(Difference between revisions)
Jump to: navigation, search
(add another FAQ link (suggested by azeem, thanks))
(add precise)
Line 37: Line 37:
 
==News==
 
==News==
  
 +
* 2012-11-22: Ubuntu Precise (12.4) added to the repository, and built 9.2.1, 9.1.6, 9.0.10, 8.4.14, 8.3.21 for it.
 
* 2012-10-13: Repository key renewed with new expiry date.
 
* 2012-10-13: Repository key renewed with new expiry date.
 
* 2012-10-02: Minor releases 9.2.1, 9.1.6, 9.0.10, 8.4.14, 8.3.21 built
 
* 2012-10-02: Minor releases 9.2.1, 9.1.6, 9.0.10, 8.4.14, 8.3.21 built
Line 42: Line 43:
 
* 2012-08-22: PostgreSQL in Debian Hackathon: [http://www.df7cb.de/blog/2012/PostgreSQL_in_Debian_Hackathon.html Blog posting] and [https://github.com/dimitri/apt.postgresql.org/blob/master/hackaton-20120821.md notes]. The distribution names changed from *-pgapt to *-pgdg, please update your sources.list.
 
* 2012-08-22: PostgreSQL in Debian Hackathon: [http://www.df7cb.de/blog/2012/PostgreSQL_in_Debian_Hackathon.html Blog posting] and [https://github.com/dimitri/apt.postgresql.org/blob/master/hackaton-20120821.md notes]. The distribution names changed from *-pgapt to *-pgdg, please update your sources.list.
 
* 2012-06-07: 9.2 added, Lenny marked unsupported now
 
* 2012-06-07: 9.2 added, Lenny marked unsupported now
* 2012-06-07: separate components "9.0", "9.2" etc added for libpq5/libpg-dev/lib... packages that would otherwise overwrite packages from other versions in the same suite. (Usually, using the latest stable libpq5 version will be ok for users. The packages built from other PostgreSQL versions are provided only for completeness.)  
+
* 2012-06-07: separate components "9.0", "9.2" etc added for libpq5/libpg-dev/lib... packages that would otherwise overwrite packages from other versions in the same suite. (Usually, using the latest stable libpq5 version will be ok for users. The packages built from other PostgreSQL versions are provided only for completeness.)
  
 
==Resources==
 
==Resources==

Revision as of 17:18, 22 November 2012

Contents

PostgreSQL packages for Debian

The PostgreSQL Global Development Group (PGDG) maintains a apt repository of PostgreSQL packages for Debian located at http://apt.postgresql.org/pub/repos/apt/. We aim at building PostgreSQL server packages as well as extensions and modules packages on several Debian releases for all PostgreSQL versions supported.

Currently, we support

  • Debian 6.0 (squeeze), 7.0 (wheezy), and unstable (sid)
  • PostgreSQL 8.3, 8.4, 9.0, 9.1, 9.2
  • Several third-party extensions such as Slony-I, various PL languages, and datatypes.

We plan to also add support for Ubuntu. 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

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. 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: 900

Update the package lists:

apt-get update

Have a look at the FAQ.

News

  • 2012-11-22: Ubuntu Precise (12.4) added to the repository, and built 9.2.1, 9.1.6, 9.0.10, 8.4.14, 8.3.21 for it.
  • 2012-10-13: Repository key renewed with new expiry date.
  • 2012-10-02: Minor releases 9.2.1, 9.1.6, 9.0.10, 8.4.14, 8.3.21 built
  • 2012-09-15: 9.2.0 is in the repository
  • 2012-08-22: PostgreSQL in Debian Hackathon: Blog posting and notes. The distribution names changed from *-pgapt to *-pgdg, please update your sources.list.
  • 2012-06-07: 9.2 added, Lenny marked unsupported now
  • 2012-06-07: separate components "9.0", "9.2" etc added for libpq5/libpg-dev/lib... packages that would otherwise overwrite packages from other versions in the same suite. (Usually, using the latest stable libpq5 version will be ok for users. The packages built from other PostgreSQL versions are provided only for completeness.)

Resources

Links

Contact

  • Mailing list: pgsql-pkg-debian@postgresql.org (Archives)
  • IRC channel: #postgresql-apt @ irc.freenode.net
  • People: Christoph Berg <myon@debian.org>, Dimitri Fontaine <dimitri@2ndquadrant.fr>, Magnus Hagander <magnus@hagander.net>

Documentation

Personal tools