This section describes how to install the PostgreSQL database server, after which you can create and initialize the databases and their users.
Limitations
| Info |
|---|
NOTE: Installation of the databases into any database schema other than PUBLIC is not supported. |
- 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: For this release, PostgreSQL 12.3 is supported on CentOS/RHEL 7 only. The following distributions and commands are for PostgreSQL 9.6 (default) is supported across all distributions. |
For CentOS/RHEL 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
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 |
|
...
After you have completed the installation, you must acquire the port information for each database from the following locations on the
. These port numbers need to be applied inside the
.
CentOS/RHEL 7 (PostgreSQL 12.3):
...
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 |
...
