Windows

Install PostgreSQL

1. Go to Download PostgreSQL page.
2. Choose and download the Windows x86-64 version.
3. Once the download is complete, run the installer.
4. When prompted, keep the default installation directory.
5. Choose the default components to install.
6. Set a password for the postgres user. Make sure to save this password for later use.

7. Select the port. Default is 5432.

8. Choose the default locale for the new database cluster.
9. Complete the installation process.

Open connection

1. Locate the PostgreSQL data directory on your server.

xxxxxxxxxx

C:\Program Files\PostgreSQL\<version>\data\

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.