The Red Hat family of distributions includes:
and others.
PostgreSQL is available on these platforms by default. However, each version of the platform normally "snapshots" a specific version of PostgreSQL that is then supported throughout the lifetime of this platform. Since this can often mean a different version than preferred, the PostgreSQL project provides a repository of packages of all supported versions for the most common distributions.
The PostgreSQL Yum 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 Yum Repository currently supports:
*Note: due to the shorter support cycle on Fedora, all supported versions of PostgreSQL are not available on this platform. We do not recommend using Fedora for server deployments.
To use the PostgreSQL Yum Repository, follow these steps:
These distributions all include PostgreSQL by default. To install PostgreSQL from these repositories, use the yum command on RHEL 5,6 and 7:
yum install postgresql-server
or dnf command on Fedora 27+:
dnf install postgresql-server
Which version of PostgreSQL you get will depend on the version of the distribution:
| Distribution | Version |
|---|---|
| RHEL/CentOS/SL/OL 7 | 9.2 (also supplies package rh-postgresql95 and rh-postgresql94 via SCL) |
| RHEL/CentOS/SL/OL 6 | 8.4 (also supplies package postgresql92) |
| RHEL/CentOS/SL/OL 5 | 8.1 (also supplies package postgresql84) |
| Fedora 28 | 10 |
| Fedora 27 | 9.6 |
Other Red Hat family distributions may ship a different version of PostgreSQL by default, check with your distribution vendor to be sure.
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 | libraries and client binaries |
|---|---|
| postgresql-server | core database server |
| postgresql-contrib | additional supplied modules |
| postgresql-devel | libraries and headers for C language development |
| pgadmin4 | pgAdmin 4 graphical administration utility |
Due to policies for Red Hat family distributions, the PostgreSQL installation will not be enabled for automatic start or have the database initialized automatically. To make your database installation complete, you need to perform the following steps, based on your distribution:
service postgresql initdb chkconfig postgresql on
postgresql-setup initdb systemctl enable postgresql.service systemctl start postgresql.service
If you cannot, or do not want to, use the yum based installation method, all the RPMs that are in the yum repository are available for direct download and manual installation as well.
Generic RPM and DEB packages that provide a server-only distribution are avaliable for some 32 and 64-bit Linux distributions. These packages provide a single set of binaries and consistent packaging across different Linux distributions. They are designed for server installation where a GUI is not available and consistency across multiple distributions is a requirement.
Download the packages from BigSQL for all supported versions.
Note: The cross distribution packages do not fully integrate with the platform-specific packaging systems.
Download the installer certified 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 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.
The installers are tested by EnterpriseDB on the following platforms. They may also work on other variations or versions:
| PostgreSQL Version | 64 Bit Platforms | 32 Bit Platforms |
|---|---|---|
| 10 | RHEL / CentOS / OEL 7.x & 6.x | RHEL / CentOS / OEL 6.x |
| 9.6 | RHEL / CentOS / OEL 7.x & 6.x | RHEL / CentOS / OEL 6.x |
| 9.5 | RHEL / CentOS / OEL 7.x & 6.x | RHEL / CentOS / OEL 6.x |
| 9.4 | RHEL / CentOS / OEL 7.x & 6.x | RHEL / CentOS / OEL 6.x |
| 9.3 | RHEL / CentOS / OEL 6.x | RHEL / CentOS / OEL 6.x |
| 9.2 | RHEL / CentOS / OEL 6.x, 5.x | RHEL / CentOS / OEL 6.x, 5.x |
The source code can be found in the main file browser. Instructions for building from source can be found in the documentation.