wiki.postgresql.org Open in urlscan Pro
72.32.157.201  Public Scan

Form analysis
1 forms found in the DOM

/index.php

<form action="/index.php" id="searchform"><input type="hidden" value="Special:Search" name="title"><input type="search" name="search" placeholder="Search PostgreSQL wiki" title="Search PostgreSQL wiki [alt-shift-f]" accesskey="f"
    id="searchInput"><input type="submit" name="go" value="Go" title="Go to a page with this exact name if it exists" id="searchGoButton" class="searchButton">&nbsp; <input type="submit" name="fulltext" value="Search"
    title="Search the pages for this text" id="mw-searchButton" class="searchButton"></form>

Text Content

Want to edit, but don't see an edit button when logged in? Click here.




APT

From PostgreSQL wiki


Jump to navigationJump to search


CONTENTS

 * 1 PostgreSQL packages for Debian and Ubuntu
 * 2 Quickstart
 * 3 Manual Repository Configuration
 * 4 Notes
 * 5 News
 * 6 Resources
   * 6.1 Contact
   * 6.2 Maintainers
     * 6.2.1 Past Contributors
   * 6.3 Bugs
   * 6.4 Documentation
 * 7 Acknowledgements


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
https://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 buster (10), bullseye (11), bookworm (12), trixie (testing/13) and sid
   (unstable)
 * Ubuntu focal (20.04), jammy (22.04), lunar (23.04, amd64 only), mantic
   (23.10, amd64 only)
 * Architectures: amd64 (64-bit x86), i386 (32-bit x86, being phased out), arm64
   (64-bit ARM), ppc64el (little-endian 64-bit POWER), s390x (IBM z-Series)
 * PostgreSQL 10, 11, 12, 13, 14, 15, 16, 17 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.


QUICKSTART

TL;DR:

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



MANUAL REPOSITORY CONFIGURATION

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

sudo apt install curl ca-certificates
sudo install -d /usr/share/postgresql-common/pgdg
sudo curl -o /usr/share/postgresql-common/pgdg/apt.postgresql.org.asc --fail https://www.postgresql.org/media/keys/ACCC4CF8.asc


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

deb [signed-by=/usr/share/postgresql-common/pgdg/apt.postgresql.org.asc] https://apt.postgresql.org/pub/repos/apt bookworm-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 [signed-by=/usr/share/postgresql-common/pgdg/apt.postgresql.org.asc] https://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-15



NOTES

Have a look at the FAQ.

The above does not add the sources repo (deb-src) commented out; if you need
source packages, you will need to modify /etc/apt/sources.list.d/pgdg.list to
add it.

This repository provides "postgresql" and "postgresql-client" meta-packages that
depend on the latest postgresql-xy, ... 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-15" instead of "postgresql".

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


NEWS

 * 2023-11-20: New architecture s390x:
   https://www.cybertec-postgresql.com/en/postgresql-on-s390x/
 * 2023-11-05: Ubuntu bionic (18.04) and kinetic (22.10) removed from
   apt.postgresql.org.
 * 2023-08-17: Ubuntu bionic (18.04) moving to apt-archive.postgresql.org:
   https://www.postgresql.org/message-id/ZN4OigxPJA236qlg%40msg.df7cb.de
 * 2022-11-11: Repository key handling changed:
   https://www.postgresql.org/message-id/Y25%2BRkZxiZKBOKio%40msg.df7cb.de
 * 2022-11-07: Debian stretch (9) has been removed:
   https://www.postgresql.org/message-id/Y2kmqL%2BpCuSZiQBV%40msg.df7cb.de
 * 2022-09-19: Ubuntu xenial and impish have been removed from
   apt.postgresql.org.
 * 2022-08-12: Debian stretch (9) is no longer supported and will be removed
   from apt.postgresql.org at the end of October:
   https://www.postgresql.org/message-id/YvZaQJpK2TE0nw%2BK%40msg.df7cb.de
 * 2022-07-24: Ubuntu impish (21.10) is no longer supported
 * 2022-07-06: Ubuntu groovy (20.10) and hirsute (21.04) have been migrated to
   apt-archive.postgresql.org. xenial (16.04) has been copied as well, and will
   be removed from apt.postgresql.org at the end of August.
 * 2022-07-05:
   * PostgreSQL 16devel packages added, see Apt/FAQ#Development_snapshots
   * The repository now features *-pgdg-snapshot distributions with snapshot
     builds of all packages
   * We have a Twitter feed now
 * 2022-02-16: Ubuntu jammy (22.04) added, hirsute (21.04) is no longer
   supported
 * 2021-09-30: PostgreSQL 14 released
 * 2021-08-12: Ubuntu impish (21.10) support added; groovy is no longer
   supported
 * 2021-06-30: PostgreSQL 15devel packages added, see
   Apt/FAQ#Development_snapshots
 * 2021-05-20: PostgreSQL 14beta1 added, Ubuntu xenial (16.04) deprecated,
   Ubuntu hirsute (21.04) added
 * 2021-01-28: Distributions moving to apt-archive.postgresql.org: jessie wheezy
   eoan disco trusty precise:
   https://www.postgresql.org/message-id/YBMtd6nRuXyU2zS4%40msg.df7cb.de

Older news items: Apt/OldNews


RESOURCES

 * FAQ
 * Package repository
 * PostgreSQL in Debian


CONTACT

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


MAINTAINERS

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

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

 * Apt/RepoDocs
 * Apt/Jenkins
 * Apt/NewPostgreSQLVersion


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

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





NAVIGATION MENU


PAGE ACTIONS

 * Page
 * Discussion
 * View source
 * History


PAGE ACTIONS

 * Page
 * Discussion
 * More
 * Tools
 * In other languages


PERSONAL TOOLS

 * Log in




NAVIGATION

 * Main Page
 * Random page
 * Recent changes
 * Help


TOOLS

 * What links here
 * Related changes
 * Special pages
 * Printable version
 * Permanent link
 * Page information


SEARCH

 

 * This page was last edited on 20 November 2023, at 15:35.
 * Privacy policy
 * About PostgreSQL wiki
 * Disclaimers