Prepare the servers for installation

General preparation

We recommend that you have 4 dedicated nodes: one for the Data Governance Center service and Search service, one for Collibra Console, one for the Repository service, and one for Jobserver if applicable. Make sure that you have a fast network between the nodes.
You have downloaded the Collibra Platform Self-Hosted installer on all nodes.

Note Java is not a required prerequisite for the Collibra installation, as the installer includes its own bundled Java Runtime Environment (JRE).

PostgreSQL on Linux

If you are installing Collibra Platform Self-Hosted on Linux, you must install the latest stable version of PostgreSQL on any server that runs one of the following services:

Repository
Jobserver
Collibra Console

You can find the latest stable version of PostgreSQL and its documentation on the PostgreSQL website.

Note The most stable version of PostgreSQL 14.x is included in the Windows installer and will be automatically installed during the CPSH installation.

Installation Methods

With Internet connection
Without Internet connection

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

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.
Reboot the server.

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

Download the necessary PostgreSQL packages

On a server with Internet access:

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

Update the package list:
```
sudo yum -y update
```
Install the yum-utils:
```
sudo yum install -y yum-utils
```
Get the web links for the necessary PostgreSQL packages and their dependencies:
```
yumdownloader --urls -y postgresql14 postgresql14-contrib postgresql14-server
```
Download packages and their dependencies:
```
yumdownloader --resolve -y postgresql14 postgresql14-contrib postgresql14-server
```
Important The list and names of the packages depend on your distro version. The following packages must always be included:
- lz4-1.9.3-5.el9.x86_64.rpm
- postgresql14-14.<minor version>PGDG.rhel9.x86_64.rpm
- postgresql14-contrib-14.<minor version>PGDG.rhel9.x86_64.rpm
- postgresql14-libs-14.<minor version>PGDG.rhel9.x86_64.rpm
- postgresql14-server-14.<minor version>PGDG.rhel9.x86_64.rpm
Copy the downloaded packages to the server on which you want to install the moss stable version of PostgreSQL 14.xx.

Install PostgreSQL

From the directory that contains the packages, run the following command to install the PostgreSQL packages:
```
sudo yum localinstall -y *.rpm
```
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.
Reboot the server.

Operating system configuration for Search service

The node that will run the Search service, must pass the following bootstrap checks:

Type	Check description	Minimum value	Applies for installation type	Setting name
User limit	Maximum number of open file descriptors	65536	Without root permissions With root permissions, using System V init daemon	nofile
	Maximum number of open threads/processes	4096		nproc
	Maximum file size	unlimited		fsize
Kernel parameter	Maximum virtual memory areas	262144	All	vm.max_map_count

For more information on these settings, see the Settings section.