To verify that Artifactory successfully connected to your PostgreSQL HA setup and is replicating the data from the primary node to the secondary node(s), you should execute the following test:
1. Configure the PostgreSQL HA setup.
2. Upload an artifact to Artifactory.
3. Stop the PostgreSQL primary node, you should expect a short downtime while Artifactory reestablishes the database connection.
4. Monitor the access-service.log file and look for the following message.
2. Upload an artifact to Artifactory.
3. Stop the PostgreSQL primary node, you should expect a short downtime while Artifactory reestablishes the database connection.
4. Monitor the access-service.log file and look for the following message.
2023-03-13T15:13:27.943Z [jfac ] [INFO ] [ ] [alConfigurationServiceBase:188] [c-default-executor-7] - Loading configuration from db finished successfully
5. Access the Artifactory UI using incognito mode (in order to avoid caching) and verify you are able to download the artifact you uploaded in step 2.