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
Debian/Ubuntu

Go to download.postgresql.org/pub/repos/yum/.
Go to the 14 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-14.7-1PGDG.rhel9.x86_64.rpm
- postgresql11-contrib-14.7-1PGDG.rhel9.x86_64.rpm
- postgresql11-server-14.7-1PGDG.rhel9.x86_64.rpm
- postgresql11-libs-14.7-1PGDG.rhel9.x86_64.rpm
Save the files on the server.

Run the following command to install the PostgreSQL packages:

yum localinstall postgresql11-14.7-1PGDG.rhel9.x86_64.rpm \
postgresql11-contrib-14.7-1PGDG.rhel9.x86_64.rpm \
postgresql11-server-14.7-1PGDG.rhel9.x86_64.rpm \
postgresql11-libs-14.7-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.

On a server with Internet access, download the necessary PostgreSQL 11 packages:

Add the PostgreSQL repository:

sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

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

apt-get update && apt-get upgrade -y

Create a list of URIs of all necessary packages for PostgreSQL 11:

sudo apt-get --allow-unauthenticated -y install --print-uris postgresql-11 | cut -d\' -f2 | \
grep http:// > /var/tmp/download-list-pg11

Copy the created file download-list-pg11 to the folder in which you want to download the packages, for example ~/Downloads:
```
cp /var/tmp/download-list-pg11 ~/Downloads
```
Go to the folder in which you have stored the downloads file:
```
cd ~/Downloads
```
Download all packages:
```
wget -i download-list-pg11
```
Copy the downloaded packages to the server on which you want to install PostgreSQL 11.

Install PostgreSQL 11:

On the server on which you want to install PostgreSQL 11, go to the directory that contains the .deb files.
Install PostgreSQL 11 with the following command:
```
sudo dpkg -i *.deb
```
Update the file /usr/lib/tmpfiles.d/postgresql-common.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.