Linux

Info

PostgreSQL version 16.9 or higher is required.

Debian, Ubuntu

Install PostgreSQL

  1. Add the official PostgreSQL repository.

sudo apt install -y postgresql-common sudo /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh # Automated get VERSION_CODENAME source /etc/os-release echo "Using VERSION_CODENAME: $VERSION_CODENAME" # Add PostgreSQL software repository sudo tee /etc/apt/sources.list.d/pgdg.sources <<EOF Types: deb deb-src URIs: https://apt.postgresql.org/pub/repos/apt Suites: $(echo $VERSION_CODENAME)-pgdg Architectures: amd64 Components: main Signed-By: /usr/share/postgresql-common/pgdg/apt.postgresql.org.asc EOF sudo apt update

  1. Install PostgreSQL 16.

sudo apt install -y postgresql-16

  1. Install additional supplied modules and extensions.

sudo apt install -y postgresql-contrib

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

sudo systemctl enable --now postgresql

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

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

Open connection

  1. Locate the PostgreSQL data directory on your server.

/etc/postgresql/<version>/main/

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

listen_addresses = '*'

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

host all all 0.0.0.0/0 scram-sha-256

  1. Restart the PostgreSQL service to apply the changes.

sudo systemctl restart postgresql

Rocky, RHEL 9

Install PostgreSQL

  1. Copy, paste, and run the relevant parts of the setup script:

sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm sudo dnf install -y postgresql16-server sudo /usr/pgsql-16/bin/postgresql-16-setup initdb sudo systemctl enable postgresql-16 sudo systemctl start postgresql-16

  1. Install additional supplied modules and extensions.

sudo dnf install -y postgresql16-contrib

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

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

Open connection

  1. Locate the PostgreSQL data directory on your server.

/var/lib/pgsql/16/data

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

listen_addresses = '*'

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

host all all 0.0.0.0/0 scram-sha-256

  1. Restart the PostgreSQL service to apply the changes.

sudo systemctl restart postgresql-16


Next to read:
Air-gapped
null
On This Page
LinuxDebian, UbuntuRocky, RHEL 9Install PostgreSQLOpen connectionInstall PostgreSQLOpen connection