Install PostgreSQL 11 on Linux

Before you can install Collibra Data Governance Center on Linux distributions, you have to manually install PostgreSQL 11.

  1. Install PostgreSQL 11 with the following commands.
    yum clean all && yum update -y
    
    #RHEL/CentOS 7
    yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
    #RHEL/Rocky 8 yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm #RHEL/Rocky 9 yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm yum -y update
    yum -y install postgresql11 postgresql11-server postgresql11-contrib
  2. After the installation, 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.
    d /run/postgresql 2777 postgres postgres - -
  3. Reboot the server.

Tip The default PostgreSQL 11path on RHEL/CentOS is /usr/pgsql-11.

  1. Install PostgreSQL 11 with the following commands:

    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

    apt-get install -y postgresql-11
  2. After the installation, 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.
    d /run/postgresql 2777 postgres postgres - -
  3. Reboot the server.

Tip The default PostgreSQL 11path on Debian/Ubuntu is /usr/lib/postgresql11.

  1. Install PostgreSQL 11 with the following commands:

    zypper addrepo https://download.opensuse.org/repositories/server:database:postgresql/SLE_15_SP3/server:database:postgresql.repo
    zypper refresh
    zypper -y install postgresql11 postgresql11-server postgresql11-contrib
  2. After the installation, update the file /usr/lib/tmpfiles.d/postgresql.conf to set the correct permissions for some PostgreSQL 11 folders. Open the file for editing, for example with vim or nano.
    d /run/postgresql 2777 postgres postgres - -
  3. Reboot the server.

Tip The default PostgreSQL 11path on Suse is /usr/lib/postgresql11.

What's next?

After the installation of the database binaries is completed, you must run the DGC installer to allow you to:

  • Pick the target directory of Collibra (Default: /opt).
  • Specify where the Postgres binaries are.
If you want to choose a non-standard directory for Postgres binaries, ensure that you set the postgresqlPath for unattended installation.