Create the PostgreSQL Database for the Ansible Installation

JFrog Installation & Setup Documentation

Content Type
Installation & Setup
ft:sourceType
Paligo

Note

For information about supported versions of PostgreSQL, see Artifactory PostgreSQL Support.

Use the following commands to create an Artifactory user and database with appropriate permissions. Modify the relevant values to match your specific environment.

Creating an 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;

Once you verify that the script is correct, run the script to create the database and proceed with the database configuration.

Note

We recommend providing Artifactory with full privileges on the database.