LINUX DOWNLOADS POSTGRESQL INSTALLATION

LINUX DOWNLOADS POSTGRESQL INSTALLATION

Quick Links

o    Downloads

o    Binary

o    Source

o    Software Catalogue

o    File Browser

Linux downloads (Red Hat family) 

The Red Hat family of distributions includes:

·         Red Hat Enterprise Linux

·         CentOS

·         Fedora

·         Scientific Linux

·         Oracle Linux

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.

PostgreSQL Yum Repository

The PostgreSQL YumRepository 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:

·         Red Hat Enterprise Linux

·         CentOS

·         Scientific Linux

·         Oracle Linux

·         Fedora*

*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:

1.   Select version: 
9.6

2.   Select platform: 
RedHat Enterprise, CentOS, Scientific or Oracle version 7

3.   Select architecture: 
x86_64

4.   Install the repository RPM:

yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

5.   Install the client packages:

yum install postgresql96

6.   Optionally install the server packages:

yum install postgresql96-server

7.   Optionally initialize the database and enable automatic start:

/usr/pgsql-9.6/bin/postgresql96-setup initdb
systemctl enable postgresql-9.6
systemctl start postgresql-9.6

Included in Distribution

These distributions all include PostgreSQL by default. To install PostgreSQL from these repositories, use the yum command on RHEL 6 and 7:

yum install postgresql-server

or dnf command on RHEL 8 and Fedora 29+:

dnf install postgresql-server

Which version of PostgreSQL you get will depend on the version of the distribution:

Distribution

Version

RHEL/CentOS/OL 8

10 and 9.6 via modules

RHEL/CentOS/SL/OL 7

9.2 (also supplies package rh-postgresql10, rh-postgresql96, rh-postgresql95 and rh-postgresql94 via SCL)

RHEL/CentOS/SL/OL 6

8.4 (also supplies package rh-postgresql96, via SCL)

Fedora 31

11

Fedora 30

11

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

Post-installation

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:

For RHEL / CentOS / SL / OL 6

  service postgresqlinitdb

chkconfigpostgresql on

For RHEL / CentOS / SL / OL 7, 8 Or Fedora 29 And Later Derived Distributions:

postgresql-setup initdb

systemctl enable postgresql.service

systemctl start postgresql.service

Direct RPM download

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.

Cross distribution packages

Generic RPM and DEB packages that provide a server-only distribution are available 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.