From PostgreSQL wiki
Jump to navigationJump to search

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 10 (buster), 11 (bullseye), 12 (bookworm), and unstable (sid)
  • Ubuntu 18.04 (bionic), 20.04 (focal), 22.04 (jammy), 22.10 (kinetic)
  • Architectures: amd64 (64-bit x86), i386 (32-bit x86, being phased out), arm64 (64-bit ARM), ppc64el (little-endian 64-bit POWER)
  • PostgreSQL 10, 11, 12, 13, 14, 15, 16 devel
  • Server extensions such as Slony-I, various PL languages, and datatypes
  • Applications like omnidb, pgbouncer, and pgpool-II

Packages for older PostgreSQL versions and older Debian/Ubuntu distributions are deprecated but will continue to stay in the repository (or be moved to apt-archive.postgresql.org), and will usually not be updated anymore.


Import the repository key from https://www.postgresql.org/media/keys/ACCC4CF8.asc:

sudo apt install curl ca-certificates gnupg
curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | gpg --dearmor | sudo tee /etc/apt/trusted.gpg.d/apt.postgresql.org.gpg >/dev/null

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

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

(You may determine the codename of your distribution by running lsb_release -c). For a script version of the above file creation, 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'

Finally, update the package lists, and start installing packages:

sudo apt update
sudo apt install postgresql-14

Alternately, this shell script will automate the repository setup. The script is included in the postgresql-common package in Debian and Ubuntu, so you can also run it straight from there:

sudo apt install postgresql-common
sudo sh /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh

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-11" instead of "postgresql".

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


Older news items: Apt/OldNews



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


  • Christoph Berg (Cybertec)
  • Marco Nenciarini (EnterpriseDB)
  • Michael Banck (credativ)

Past Contributors

  • Dimitri Fontaine
  • Magnus Hagander


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.



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 Jenkins CI server is kindly hosted by DG-i.

The ARM build server is kindly hosted by HUAWEI Cloud Services.

The ppc64el build server is kindly hosted by IBM Power Systems Linux Center, Montpellier.

The s390x build server is kindly hosted by the IBM LinuxONE Community Cloud at Marist College.

The repository and the x86 build server are hosted on postgresql.org hardware.