{%extends "base/page.html"%} {%block title%}Linux downloads (Debian){%endblock%} {%block extrahead%} {%endblock%} {%block contents%}

Linux downloads (Debian)

PostgreSQL is available in all Debian versions by default. However, the stable versions of Debians "snapshot" a specific version of PostgreSQL that is then supported throughout the lifetime of that Debian version. The PostgreSQL project also maintains an apt repository with all supported of PostgreSQL available.

PostgreSQL Apt Repository

If the version included in your version of Debian is not the one you want, you can use the PostgreSQL Apt Repository. This repository will integrate with your normal systems and patch management, and provide automatic updates for all supported versions of PostgreSQL throughout the support lifetime of PostgreSQL.

The PostgreSQL apt repository supports the currently supported stable versions of Debian:

on the following architectures:

To use the apt repository, follow these steps:

# Create the file repository configuration:
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 signing key:
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

# Update the package lists:
sudo apt-get update

# Install the latest version of PostgreSQL.
# If you want a specific version, use 'postgresql-12' or similar instead of 'postgresql':
sudo apt-get install postgresql

For more information about the apt repository, including answers to frequent questions, please see the apt page on the wiki.

Included in distribution

Debian includes PostgreSQL by default. To install PostgreSQL on Debian, use the apt-get (or other apt-driving) command:

  apt-get install postgresql-12

The repository contains many different packages including third party addons. The most common and important packages are (substitute the version number as required):

postgresql-client-12 client libraries and client binaries
postgresql-12 core database server
postgresql-contrib-9.x additional supplied modules (part of the postgresql-xx package in version 10 and later)
libpq-dev libraries and headers for C language frontend development
postgresql-server-dev-12 libraries and headers for C language backend development
pgadmin4 pgAdmin 4 graphical administration utility

Debian backports

Newer versions of PostgreSQL for older versions of Debians are available in Debian backports. For information on how to enable and use the backports repository, please see the backports instructions page at Debian.

Once backports is enabled, you can install PostgreSQL the same way as with the builtin repositories.

{%include "pages/download/linux/linux_oneclick.inc" %}

Platform support

The installers are tested by EDB on the following platforms. They may also work on other variations or versions:

PostgreSQL Version 64 Bit Platforms 32 Bit Platforms
10 Debian 8.x & 7.x  
9.6 Debian 8.x & 7.x  
9.5 Debian 7.x Debian 7.x
{%include "pages/download/linux/linux_source.inc" %} {%endblock%}