|
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 -y 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.
Interactive installer by EDB
Download the installer certified by EDB for PostgreSQL 10.x and earlier.
Note: Installers for Linux are no longer being product for PostgreSQL 11 and later. Users are advised to use platform native packages instead.
This installer includes the PostgreSQL server, pgAdmin; a graphical tool for managing and developing your databases, and StackBuilder; a package manager that can be used to download and install additional PostgreSQL tools and drivers. Stackbuilder includes management, integration, migration, replication, geospatial, connectors and other tools.
This installer can run in graphical, command line, or silent install modes.
The installer is designed to be a straightforward, fast way to get up and running with PostgreSQL on Linux (Red Hat family Linux including CentOS/Fedora/Scientific/Oracle variants), Debian GNU/Linux and derivatives, Ubuntu Linux and derivatives, SuSE and OpenSuSE.
Advanced users can also download a tar.gz archive of the binaries, without the installer. This download is intended for users who wish to include PostgreSQL as part of another application installer.
Note: The installers do not integrate with platform-specific packaging systems.
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 |
Build from source
The source code can be found in the main file browser. Instructions for building from source can be found in the documentation.