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
  • Suse Linux Enterprise
  1. Go to download.postgresql.org/pub/repos/yum/.
  2. Go to the 11 folder and then redhat.
  3. Go to the folder of your distribution version, for example rhel-9-x86_64.

    Tip Run rpm -E %rhel to know your distribution version.

  4. 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
  5. Save the files on the server.
  6. 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
  1. Go to download.postgresql.org/pub/repos/apt/pool/main/p/postgresql-11/.
  2. Download the package postgresql-11_11.17-1.pgdg120+1+b1_amd64.deb
  3. Save the file on the server.
  4. Run the following command to install the PostgreSQL packages:
    dpkg -i postgresql-11_11.17-1.pgdg120+1+b1_amd64.deb
  1. Go to download.postgresql.org/pub/repos/zypp/.
  2. Go to the 11 folder and then suse.
  3. Go to the folder of your Suse version, for example sles-15.4-x86_64.
  4. Download the following packages:

    Important Ensure you download the package for your Suse version.

    • postgresql11-11.17-1PGDG.sles15.x86_64.rpm
    • postgresql11-contrib-11.17-1PGDG.sles15.x86_64.rpm
    • postgresql11-server-11.17-1PGDG.sles15.x86_64.rpm
  5. Save the files on the server.
  6. Run the following command to install the PostgreSQL packages:
    rpm -i postgresql11-11.17-1PGDG.sles15.x86_64.rpm \
postgresql11-contrib-11.17-1PGDG.sles15.x86_64.rpm \
postgresql11-server-11.17-1PGDG.sles15.x86_64.rpm