Artifactory PostgreSQL Database Creation

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

Create an Artifactory User and Database as a superuser

-- Replace <REPLACE_WITH_DB_PASSWORD> with a quoted password before running this script.
CREATE USER artifactory WITH PASSWORD <REPLACE_WITH_DB_PASSWORD>;
CREATE DATABASE artifactory WITH OWNER=artifactory ENCODING='UTF8';
GRANT ALL PRIVILEGES ON DATABASE artifactory TO artifactory;

Create an Artifactory user and database with a restricted superuser (such as rds_superuser used by AWS RDS)

-- Replace <REPLACE_WITH_DB_PASSWORD> with a quoted password before running this script.
CREATE USER artifactory WITH PASSWORD <REPLACE_WITH_DB_PASSWORD>;
ALTER ROLE artifactory WITH CREATEDB;

## Connect with the new user
\c <current-database> artifactory

## Create a new database and grant full privileges
CREATE DATABASE artifactory WITH OWNER=artifactory ENCODING='UTF8';
GRANT ALL PRIVILEGES ON DATABASE artifactory TO artifactory;

❗
Replace the placeholder password
These examples use a placeholder instead of a runnable default password. Replace <REPLACE_WITH_DB_PASSWORD> with a strong password of your own choosing before running either script, and use that same password when you set shared.database.password in system.yaml (or the supported environment-variable override). Do not leave the placeholder in a production setup.

Verify that the script is correct for your environment — including the database name, username, host restrictions, and granted privileges — and run it to create the database.

📘
Artifactory Privileges
You must give Artifactory full privileges on the database.

Related Topics