Try JFrog
Guides
Contact SupportTry JFrog
  1. Configurations
  2. Database Configuration
  3. PostgreSQL for Artifactory

Artifactory PostgreSQL Database Creation

Create the PostgreSQL user and database for JFrog Artifactory using SQL commands for both standard superuser and restricted superuser (e.g., AWS RDS) environments.

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

CREATE USER artifactory WITH PASSWORD '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)

CREATE USER artifactory WITH PASSWORD '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;

Verify that the script is correct for your environment, and run it to create the database.

📘

Artifactory Privileges

You must give Artifactory full privileges on the database.

Updated 9 days ago