PostgreSQL for Artifactory
Configure PostgreSQL as the database for JFrog Artifactory, the recommended engine for all deployments and the only database shared across all JFrog products.
PostgreSQL provides infrastructure features such as backup and restore. All other JFrog products support only PostgreSQL, so using PostgreSQL with Artifactory simplifies your infrastructure.
For more information about the supported PostgreSQL versions, see Artifactory PostgreSQL Support.
Create the Artifactory PostgreSQL Database
Create the PostgreSQL user and database with required permissions for JFrog Artifactory.
Enable PostgreSQL Connectivity from Remote Servers
Configure pg_hba.conf to allow remote access to PostgreSQL from Artifactory nodes.
Configure Artifactory to Use PostgreSQL
Configure Artifactory to store metadata in PostgreSQL using system.yaml settings.
Configure Artifactory Single Node with PostgreSQL
Configure a single-node Artifactory with PostgreSQL via the system.yaml database block.
Configure Artifactory HA with PostgreSQL HA
Configure Artifactory HA to use PostgreSQL HA connection strings in system.yaml.
Configure Advisory Locks in PostgreSQL
Enable PostgreSQL advisory locks as an alternative to distributed table locks.
Enable TLS Encryption for PostgreSQL
Enable TLS encryption for PostgreSQL via sslmode in the JDBC connector URL.
Updated 3 days ago