Artifactory supports PostgreSQL version 13.x and below (9.5 and 9.6 were EOL in 2021).
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.
We recommend providing Artifactory with full privileges on the database.