Install PostgreSQL 11 without Internet access

On Linux operating systems, you have to install PostgreSQL 11 before you can install Collibra Data Intelligence Cloud.

Tip On Windows, PostgreSQL is bundled in the installer.

The server on which you want to install PostgreSQL 11 needs Internet access. If this is restricted, you can still install it by downloading the necessary packages on a computer with Internet access and then copy them over to the server.

RHEL/CentOS/Rocky Linux 9

Go to download.postgresql.org/pub/repos/yum/.
Go to the 11 folder and then redhat.
Go to the folder of your distribution version, for example rhel-9-x86_64.
Tip Run rpm -E %rhel to know your distribution version.
Download the following packages:
Important The name of the packages depend on your distro version.
- postgresql11-11.17-1PGDG.rhel9.x86_64.rpm
- postgresql11-contrib-11.17-1PGDG.rhel9.x86_64.rpm
- postgresql11-server-11.17-1PGDG.rhel9.x86_64.rpm
- postgresql11-libs-11.17-1PGDG.rhel9.x86_64.rpm
Save the files on the server.

Run the following command to install the PostgreSQL packages:

yum localinstall postgresql11-11.17-1PGDG.rhel9.x86_64.rpm \
postgresql11-contrib-11.17-1PGDG.rhel9.x86_64.rpm \
postgresql11-server-11.17-1PGDG.rhel9.x86_64.rpm \
postgresql11-libs-11.17-1PGDG.rhel9.x86_64.rpm

Update the file /usr/lib/tmpfiles.d/postgresql-11.conf to set the correct permissions for some PostgreSQL 11 folders. Open the file for editing, for example with vim or nano.
```
#update this line:
d /run/postgresql 0755 postgres postgres -
			
#to:
d /run/postgresql 2777 postgres postgres - -
```
Important Do not use the chmod command on any directories or files, edit this configuration file instead.
Reboot the server.