Artifactory HA PostgreSQL Configuration with Ansible

You can deploy external PostgreSQL instances in High Availability configurations for increased resiliency.

To configure Artifactory HA with PostgreSQL HA:

1. Stop the Artifactory service.

2. Edit the system.yaml file and update the following values.

   The url field under both the shared and metadata database sections in the following format.

   XML

   jdbc:postgresql://<PostgreSQL Database 1 URL>,..., <PostgreSQL Database N URL>/artifactory?targetServerType=primary

📘

Understanding the connection parameters

The targetServerType=primary parameter applies to the entire connection, not to any individual host in the list. List all PostgreSQL HA nodes (primary and replicas) in the URL, separated by commas. The JDBC driver automatically discovers which node is currently the primary and connects to it.

This enables automatic failover: if the primary changes, the driver reconnects to the new primary on the next connection attempt.

The following sample shows an example system.yaml file configuration.

systemYaml:
 shared:
   logging:
   ...
   database:
     type: postgresql
     url: "jdbc:postgresql://17.21.0.2:5432,17.21.0.3:5432/artifactory?targetServerType=primary"
     driver: org.postgresql.Driver
     username: "artifactory"
     password: "password"
 artifactory:
   Database:
 ...
 frontend:
 ...
 access:
 ...
 metadata:
   database:
     type: postgresql
     url: "jdbc:postgresql://17.21.0.2:5432,17.21.0.3:5432/artifactory?targetServerType=primary"
     driver: org.postgresql.Driver
     username: "artifactory"
     password: "password"
...

3. Start the Artifactory service.