Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r0711

D toc

This section describes how to install the PostgreSQL database server, after which you can create and initialize the databases and their users.

Limitations

  • You must install a supported version of the database. For more information on supported versions of this database type, see System Requirements in the Planning Guide.
  • SSL connections are not supported.

...

Database Install

Excerpt
Info

NOTE: The following distributions and commands are for For this release, PostgreSQL 12.3 is supported on CentOS 7 only. PostgreSQL 9.6 (default) is supported across all distributions.

For CentOS 7.x - PostgreSQL 12.3:

Code Block
wget https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
sudo yum -y install pgdg-redhat-repo-latest.noarch.rpm
sudo yum -y install postgresql12-server


For CentOS 7.x:

Code Block
wget https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-redhat-repo-42.0-9.noarch.rpm
sudo yum -y install pgdg-redhat-repo-42.0-9.noarch.rpm
sudo yum -y install postgresql96-server

For CentOS 8.x:

Code Block
wget https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-8.1-x86_64/pgdg-redhat-repo-42.0-9.noarch.rpm
sudo yum -y install pgdg-redhat-repo-42.0-9.noarch.rpm
sudo yum -y install postgresql96-server

For Red Hat Enterprise Linux 7.x:

Code Block
wget https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-redhat-repo-42.0-9.noarch.rpm
sudo yum -y install pgdg-redhat-repo-42.0-9.noarch.rpm
sudo yum -y install postgresql96-server


For Red Hat Enterprise Linux 8.x:

Code Block
wget https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-8.1-x86_64/pgdg-redhat-repo-42.0-9.noarch.rpm
sudo yum -y install pgdg-redhat-repo-42.0-9.noarch.rpm
sudo yum -y install postgresql96-server

For Ubuntu 16.04:

Add the repository's archive key to your apt-key keyring:

Code Block
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

Create a file named /etc/apt/sources.list.d/pgdg.list, containing the following:

Code Block
deb http://apt.postgresql.org/pub/repos/apt/xenial-pgdg main

Run the following command:

Code Block
sudo apt-get update
sudo apt-get install -y postgresql-9.6

For Ubuntu 18.04:

Add the repository's archive key to your apt-key keyring:

Code Block
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

Create a file named /etc/apt/sources.list.d/pgdg.list, containing the following:

Code Block
deb http://apt.postgresql.org/pub/repos/apt/bionic-pgdg main

Run the following command:

Code Block
sudo apt-get update
sudo apt-get install -y postgresql-9.6

...

d-s-pssql-port

CentOS/RHEL 7 (PostgreSQL 12.3):

Code Block
/var/lib/pgsql/12/data/postgresql.conf

CentOS/RHEL (PostgreSQL 9.6):

Code Block
/var/lib/pgsql/9.6/data/postgresql.conf

Ubuntu (PostgreSQL 9.6) :

Code Block
/etc/postgresql/9.6/main/postgresql.conf