PostgreSQL Database High Availability is a new database set-up supported by Artifactory 7.31.10 and above with PostgreSQL 13.x.
This database set-up is configured using primary and secondary nodes.
Artifactory opens up connections to the PostgreSQL HA primary node, and the primary node replicates its data to the other PostgreSQL HA nodes.
As shown in the following diagram, the replication between the PostgreSQL nodes keeps them in sync in case the primary node fails.
When the primary node becomes unavailable, Artifactory will automatically connect to the next PostgreSQL node in the chain, which becomes the current “primary” node.
The motivation behind this database set-up is to enable automatic recovery from database failures which could prevent Artifactory system downtime.
This database set-up is configured using primary and secondary nodes.
Artifactory opens up connections to the PostgreSQL HA primary node, and the primary node replicates its data to the other PostgreSQL HA nodes.
As shown in the following diagram, the replication between the PostgreSQL nodes keeps them in sync in case the primary node fails.
When the primary node becomes unavailable, Artifactory will automatically connect to the next PostgreSQL node in the chain, which becomes the current “primary” node.
The motivation behind this database set-up is to enable automatic recovery from database failures which could prevent Artifactory system downtime.