PostgreSQL for Artifactory

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.

⚠️
Deprecation heads-up
Artifactory Self-Managed support for PostgreSQL 13 and PostgreSQL 14 is deprecated.

PostgreSQL 13 reached vendor end of life on November 13, 2025.

PostgreSQL 14 will reach vendor end of life on November 12, 2026.

Upgrade to PostgreSQL 15.x to 17.x.

For more information, 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.

Related Topics