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.