Install PostgreSQL 14.7 without Internet access

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

Tip On Windows, PostgreSQL is bundled in the installer.

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

  • RHEL/CentOS/Rocky Linux
  • Debian/Ubuntu
  • Suse Linux Enterprise

Download the necessary PostgreSQL 14.7 packages

On a server with Internet access:

  1. Add the PostgreSQL repository: 
    sudo yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-$(rpm -E %{rhel})-x86_64/pgdg-redhat-repo-latest.noarch.rpm
  2. Update the package list: 
    sudo yum -y update
  3. Install the yum-utils: 
    sudo yum install -y yum-utils
  4. Get the web links for the necessary PostgreSQL packages and their dependencies: 
    yumdownloader --urls -y postgresql14 postgresql14-contrib postgresql14-server
  5. Download packages and their dependencies: 
    yumdownloader --resolve -y postgresql14 postgresql14-contrib postgresql14-server

    Important The name of the packages depend on your distro version.

    • lz4-1.9.3-5.el9.x86_64.rpm
    • postgresql14.7-14.7-1PGDG.rhel9.x86_64.rpm
    • postgresql14.7-contrib-14.7-1PGDG.rhel9.x86_64.rpm
    • postgresql14.7-libs-14.7-1PGDG.rhel9.x86_64.rpm
    • postgresql14.7-server-14.7-1PGDG.rhel9.x86_64.rpm

  6. Copy the downloaded packages to the server on which you want to install PostgreSQL 14.7.

Install PostgreSQL 14.7

  1. From the directory that contains the packages, run the following command to install the PostgreSQL packages:
    sudo yum localinstall -y *.rpm
  2. Update the file /usr/lib/tmpfiles.d/postgresql-14.conf/usr/lib/tmpfiles.d/postgresql-14.conf to set the correct permissions for some PostgreSQL 14.7 folders. Open the file for editing, for example with vim or nano and update the 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.

  3. If you are upgrading from version 5.8.x to 5.9, you also have to update the configuration file of PostgreSQL 11 (/usr/lib/tmpfiles.d/postgresql-11.conf) as described in the previous step.
  4. Reboot the server.

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

  1. 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
  2. Create a list of URIs of all necessary packages for PostgreSQL 14.7: 
    sudo apt-get --allow-unauthenticated -y install --print-uris postgresql-14 | cut -d\' -f2 | \
grep http:// > /var/tmp/download-list-pg14
  3. Copy the created file download-list-pg14 to the folder in which you want to download the packages, for example ~/Downloads: 
    cp /var/tmp/download-list-pg14 ~/Downloads
  4. Go to the folder in which you have stored the downloads file: 
    cd ~/Downloads
  5. Download all packages: 
    wget -i download-list-pg14
  6. Copy the downloaded packages to the server on which you want to install PostgreSQL 14.7.

Install PostgreSQL 14.7:

  1. On the server on which you want to install PostgreSQL 14.7, go to the directory that contains the .deb files.
  2. Install PostgreSQL 14.7 with the following command: 
    sudo dpkg -i *.deb
  3. Update the file /usr/lib/tmpfiles.d/postgresql-common.conf to set the correct permissions for some PostgreSQL 14.7 folders. Open the file for editing, for example with vim or nano and update the line d /run/postgresql 1775 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.

  4. Reboot the server.
  1. Go to download.postgresql.org/pub/repos/zypp/.
  2. Go to the 14 folder and then suse.
  3. Go to the folder of your Suse version, for example sles-15.4-x86_64.

    Tip Check your Suse version with the command: cat /etc/os-release.

  4. Download the following packages:

    Important Ensure you download the package for your Suse version. In the following list, the packages are for Suse 15, replace "15" by your used major version, for example 12.

    • postgresql14-14.7-1PGDG.sles15.x86_64.rpm
    • postgresql14-contrib-14.7-1PGDG.sles15.x86_64.rpm
    • postgresql14-libs-14.7-1PGDG.sles15.x86_64.rpm
    • postgresql14-server-14.7-1PGDG.sles15.x86_64.rpm
  5. Save the packages in 1 directory on the server.
  6. From the directory that contains the packages, run the following command to install the PostgreSQL packages:
    sudo rpm -i *.rpm
  7. Update the file /usr/lib/tmpfiles.d/postgresql-14.conf/usr/lib/tmpfiles.d/postgresql-14.conf to set the correct permissions for some PostgreSQL 14.7 folders. Open the file for editing, for example with vim or nano and update the 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.

  8. If you are upgrading from version 5.8.x to 5.9, you also have to update the configuration file of PostgreSQL 11 (/usr/lib/tmpfiles.d/postgresql-11.conf) as described in the previous step.
  9. Reboot the server.