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.
Included in distribution
Debian includes Postgresql by default. To install Postgresql on Debian,use theapt-get(or other apt-driving) command:
apt-get install postgresql-9.4
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-9.4 - client libraries and client binaries
- postgresql-9.4 - core database server
- postgresql-contrib-9.4 - additional supplied modules
- libpq-dev - libraries and headers for C language frontend development
- postgresql-server-dev-9.4 - libraries and headers for C language backend development
- pgadmin3 - pgAdmin III graphical administration utility
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 supportlifetimeof Postgresql.
The Postgresql apt repository supports the currently supported stable versions of debian,squeeze (6.x) and wheezy (7.x) as well as Jessie (8.x),on amd64 and i386 architectures.
To use the apt repository,follow these steps:
- Create the file/etc/apt/sources.list.d/pgdg.list,and add a line for the repository
deb http://apt.postgresql.org/pub/repos/apt/jessie-pgdg main - Import the repository signing key,and update the package lists
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | \
sudo apt-key add -
sudo apt-get update
For more information about the apt repository,including answers to frequent questions,please see the apt page onthe wiki.
Debian backports
Newer versions of Postgresql for older versions of Debians are available inDebian backports. For information on how to enable and use the backports repository,please see thebackports instructionspage at Debian.
Once backports is enabled,you can install Postgresql the same way as with the builtin repositories.
Interactive installer by EnterpriseDB
Download the installercertified by EnterpriseDB for all supported Postgresql versions.
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 userscan also download atar.gz archiveof 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.
Build from source
The source code can be found in the mainfile browser. Instructions for building from source can be found in thedocumentation.