Linux

PostgreSQL version 16.9 or higher is required.

Prerequisites

Before installing the PostgreSQL service, ensure the following requirements are met.

Requirement	Description
Operating System	Debian 12+, Ubuntu 22.04+, Rocky Linux 9+, or RHEL 9+.
Privileges	`root` or `sudo` privileges.
Hardware	Minimum 8 vCPU and 16 GB RAM.
Disk space	At least 1 TB of available storage on SSD or NVMe for optimal performance. Approximately 4 GB of storage is required per 1 million scanned objects for a deployment with 5 MD Core instances running 8 AV engines each.
Network access	Required port is open (default port: 5432). A minimum network bandwidth of 1 Gbps is required. A bandwidth of 5 Gbps or higher is strongly recommended for production deployments.

Debian, Ubuntu

Install PostgreSQL

Add the official PostgreSQL repository.

Bash
    
xxxxxxxxxx
 
sudo apt install -y postgresql-commonsudo /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh # Automated get VERSION_CODENAMEsource /etc/os-releaseecho "Using VERSION_CODENAME: $VERSION_CODENAME" # Add PostgreSQL software repositorysudo tee /etc/apt/sources.list.d/pgdg.sources <<EOFTypes: deb deb-srcURIs: https://apt.postgresql.org/pub/repos/aptSuites: $(echo $VERSION_CODENAME)-pgdgArchitectures: amd64Components: mainSigned-By: /usr/share/postgresql-common/pgdg/apt.postgresql.org.ascEOF sudo apt update
Copy

Install PostgreSQL 16.

Bash
    
xxxxxxxxxx
 
sudo apt install -y postgresql-16
Copy

Install additional supplied modules and extensions.

Bash
    
xxxxxxxxxx
 
sudo apt install -y postgresql-contrib
Copy

Configures PostgreSQL to start automatically whenever the system boots.

Bash
    
xxxxxxxxxx
 
sudo systemctl enable --now postgresql
Copy

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

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

Open connection

Locate the PostgreSQL data directory on your server.

Bash
    
xxxxxxxxxx
 
/etc/postgresql/<version>/main/
Copy

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

postgresql.conf
    
xxxxxxxxxx
 
listen_addresses = '*'
Copy

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

pg_hba.conf
    
xxxxxxxxxx
 
host    all             all             0.0.0.0/0            scram-sha-256
Copy

Restart the PostgreSQL service to apply the changes.

Bash
    
xxxxxxxxxx
 
sudo systemctl restart postgresql
Copy

Rocky, RHEL 9

Install PostgreSQL

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

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

Install additional supplied modules and extensions.

Bash
    
xxxxxxxxxx
 
sudo dnf install -y postgresql16-contrib
Copy

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

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

Open connection

Locate the PostgreSQL data directory on your server.

Bash
    
xxxxxxxxxx
 
/var/lib/pgsql/16/data
Copy

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

postgresql.conf
    
xxxxxxxxxx
 
listen_addresses = '*'
Copy

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

pg_hba.conf
    
xxxxxxxxxx
 
host    all             all             0.0.0.0/0            scram-sha-256
Copy

Restart the PostgreSQL service to apply the changes.

Bash
    
xxxxxxxxxx
 
sudo systemctl restart postgresql-16
Copy

Last updated on

Was this page helpful?