Install PostgreSQL 14.9 on Linux

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.

If the server on which you want to install PostgreSQL 14.9 does not have Internet access, follow the instructions in this article.

Steps

  1. Install PostgreSQL 14.9 with the following commands.

    Important Run the commands as root.

    #Clean the YUM cache and update existing packages for your current Linux repository. Note that this makes system changes.
     
yum clean all && yum update -y

    #Prepare the PostgreSQL repository and packages:
yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-$(rpm -E %{rhel})-x86_64/pgdg-redhat-repo-latest.noarch.rpm

    #Update the packages in the repository:
yum -y update

    #Install the PostgreSQL 14.9 packages:
yum -y install postgresql14 postgresql14-server postgresql14-contrib
  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.

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

Note If you don't update the PostgreSQL configuration file, you get an error that a test file could not be written.

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.