1. Connect to PostgreSQL and create Artifactory user and database
CREATE USER artifactory WITH PASSWORD 'password'; CREATE DATABASE artifactory WITH OWNER=artifactory ENCODING='UTF8'; GRANT ALL PRIVILEGES ON DATABASE artifactory TO artifactory;
2. Download the JDBC driver corresponding to your PostgreSQL version from the PostgreSQL JDBC Driver Download site and copy the downloaded jar file into - $JFROG_HOME/artifactory/var/bootstrap/artifactory/tomcat/lib directory.
Make sure your driver has read permissions for all users. Note that this directory will get created on installing the compose, or you may pre-create it.
3. Enable PostgreSQL connectivity from the Artifactory servers:
Add the following line to $POSTGRES_HOME/data/pg_hba.conf
host [artifactory_db_name] [artifactory_user] [cidr] md5
Example:
host artifactory artifactory 123.456.78.90/32 md5
Add the following line to (if it already exists, update it) $POSTGRES_HOME/data/postgresql.conf
listen_addresses='*'
We recommend having sizable storage space for the database, even if it is only storing metadata. It should be at least 2/10 of your expected file store size.
Artifactory supports a number of DB types, including mysql, oracle, mariaDB. You may find the links to other supported databases below in the glossary.
For more database recommendations, see https://jfrog.com/whitepaper/best-practices-for-managing-your-artifactory-database/