Linux

Debian, Ubuntu

Install PostgreSQL

1. Add the official PostgreSQL repository.

xxxxxxxxxx

sudo apt install -y postgresql-common

sudo /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh

2. Install PostgreSQL 16.

xxxxxxxxxx

sudo apt install -y postgresql-16

4. Install additional supplied modules and extensions.

xxxxxxxxxx

sudo apt install postgresql-contrib

5. Configures PostgreSQL to start automatically whenever the system boots.

xxxxxxxxxx

sudo systemctl enable --now postgresql

6. Setup login password. Make sure to save this password for later use.

xxxxxxxxxx

sudo -u postgres psql -c "ALTER USER postgres WITH PASSWORD '<your_password>';"

Open connection

1. Locate the PostgreSQL data directory on your server.

xxxxxxxxxx

/etc/postgresql/<version>/main/

2. To allow remote connections, open the postgresql.conf file and configure the following setting:

xxxxxxxxxx

listen_addresses = '*'

3. To allow MetaDefender Cluster services to access the database, open the pg_hba.conf file and add the following rule.

xxxxxxxxxx

host    all             all             0.0.0.0/0            scram-sha-256

4. Restart the PostgreSQL service to apply the changes.

xxxxxxxxxx

sudo systemctl restart postgresql

Rocky, RHEL 9

Install PostgreSQL

1. Install the repository RPM.

sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm

2. Disable the built-in PostgreSQL modules.

xxxxxxxxxx

sudo dnf -qy module disable postgresql

3. Install PostgreSQL 16.

xxxxxxxxxx

sudo dnf install -y postgresql16-server

4. Install additional supplied modules and extensions.

xxxxxxxxxx

sudo apt install postgresql-contrib

5. Initialize the database and enable automatic start.

xxxxxxxxxx

sudo /usr/pgsql-16/bin/postgresql-16-setup initdb

sudo systemctl enable --now postgresql-16

5. Setup login password. Make sure to save this password for later use.

xxxxxxxxxx

sudo -u postgres psql -c "ALTER USER postgres WITH PASSWORD '<your_password>';"

Open connection

1. Locate the PostgreSQL data directory on your server.

xxxxxxxxxx

/etc/postgresql/<version>/main/

2. To allow remote connections, open the postgresql.conf file and configure the following setting:

xxxxxxxxxx

listen_addresses = '*'

3. To allow MetaDefender Cluster services to access the database, open the pg_hba.conf file and add the following rule.

xxxxxxxxxx

host    all             all             0.0.0.0/0            scram-sha-256

4. Restart the PostgreSQL service to apply the changes.

xxxxxxxxxx

sudo systemctl restart postgresql-16