Install PostgreSQL 14.9 without Internet access

Before you can install Collibra Data Governance Center 5.9.0 or Collibra Platform Self-Hosted on RHEL, CentOS or Rocky Linux distributions, you have to manually install PostgreSQL 14.9 on RHEL, CentOS or Rocky Linux.

Tip On Windows, PostgreSQL is bundled in the installer.

The server on which you want to install PostgreSQL 14.9 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.

Download the required PostgreSQL 14.9 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.9-14.9-1PGDG.rhel9.x86_64.rpm
    • postgresql14.9-contrib-14.9-1PGDG.rhel9.x86_64.rpm
    • postgresql14.9-libs-14.9-1PGDG.rhel9.x86_64.rpm
    • postgresql14.9-server-14.9-1PGDG.rhel9.x86_64.rpm

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

Install PostgreSQL 14.9

  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 to set the correct permissions for some PostgreSQL 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.