Apt

From PostgreSQL wiki

Jump to: navigation, search

Contents

PostgreSQL packages for Debian and Ubuntu

The PostgreSQL Global Development Group (PGDG) maintains an APT repository of PostgreSQL packages for Debian and Ubuntu 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/Ubuntu releases for all PostgreSQL versions supported.

Currently, we support

  • Debian 7 (wheezy), 8 (jessie), 9 (stretch), and unstable (sid)
  • Ubuntu 14.04 (trusty), 16.04 (xenial), 17.04 (zesty)
  • Architectures: amd64 (64-bit x86), i386 (32-bit x86), ppc64el (little-endian 64-bit POWER; not on wheezy/precise)
  • PostgreSQL 9.1, 9.2, 9.3, 9.4, 9.5, 9.6, 10devel
  • 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/Ubuntu distributions will continue to stay in the repository; updates for those will be provided on an ad-hoc basis.

Quickstart

Create /etc/apt/sources.list.d/pgdg.list. The distributions are called codename-pgdg. In the example, replace wheezy with the actual distribution you are using: 

deb http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg main

(You may determine the codename of your distribution by running lsb_release -c). For a shorthand version of the above, presuming you are using a supported release: 

sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

Import the repository key from https://www.postgresql.org/media/keys/ACCC4CF8.asc, update the package lists, and start installing packages: 

sudo apt-get install wget ca-certificates
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update
sudo apt-get upgrade
sudo apt-get install postgresql-9.5 pgadmin3

Alternately, this shell script will automate the repository setup. Note that the shell script leaves the source package repo (deb-src) commented out; if you need source packages, you will need to modify /etc/apt/sources.list.d/pgdg.list to enable it.

Have a look at the FAQ.

Note: This repository provides "postgresql", "postgresql-contrib", and "postgresql-client" meta-packages that depend on the latest postgresql-x.y, ... packages, similar to the ones present in Debian and Ubuntu. Once a new PostgreSQL version is released, these meta-packages will be updated to depend on the new version. If you rather want to stay with a particular PostgreSQL version, you should install specific packages like "postgresql-9.5" instead of "postgresql".

For packages of development/alpha/beta versions of PostgreSQL, see the FAQ entry about beta versions.

News

Older news items: Apt/OldNews

Resources

Contact

  • Mailing list: pgsql-pkg-debian@postgresql.org (Archives)
  • IRC channel: #postgresql-apt @ irc.freenode.net

Maintainers

  • Christoph Berg (credativ)
  • Marco Nenciarini (2ndQuadrant)

Past Contributors

  • Dimitri Fontaine
  • Magnus Hagander

Bugs

Please report bugs:

  • on the pgsql-pkg-debian@postgresql.org mailing list, or
  • open an issue in Redmine, or
  • open a bug in the Debian BTS.

Documentation

Acknowledgements

Work on setting up the archive was kindly supported by credativ, 2ndQuadrant, Redpill Linpro, and funding from the European Union's Seventh Framework Programme (FP7/2007-2013) under grant agreement 258862.

The amd64/i386 build server is kindly hosted by DG-i. The ppc64el build server is kindly hosted by IBM Power Systems Linux Center, Montpellier. The archive is hosted on postgresql.org hardware.

Retrieved from "https://wiki.postgresql.org/index.php?title=Apt&oldid=30182"
Personal tools