Enable PostgreSQL Connectivity from Remote Servers

JFrog Installation & Setup Documentation
Content Type
Installation & Setup
ft:sourceType
Paligo

The following is an example for enabling 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

    Example

     host  artifactory       artifactory     123.456.78.90/32 md5

    Note

    [cidr] is the single host or network segment you want to give access to.

  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 after adding the above changes.