Enable PostgreSQL Connectivity from Remote Servers

The following example shows how to enable PostgreSQL connectivity from remote servers. Consult your security team for your organization's best practices.

1. Add the following line to <postgres_mount>/data/pg_hba.conf:

   host <artifactory_db_name> <artifactory_user> <cidr> md5

   where

   artifactory_db_name is the name of the artifactory database you created.

   artifactory_user is the user that artifactory uses to interact with the database.

   cidr is the host or network segment that is granted access to the database.

   For example:

   host artifactory artifactory 123.456.78.90/32 md5

2. Add the following line to <postgres_mount>/data/postgresql.conf

   `listen_addresses='*'``

📘

Note

You can also use a specific IP address for the PostgreSQL server to listen.

3. Restart PostgreSQL.