Jfrog Artifactory: Install Artifactory 7 with Postgresql

Here’s a clear, step-by-step command guide to install the latest JFrog Artifactory (7.117.7) on a Linux server with PostgreSQL as the external database. This walkthrough assumes Ubuntu/Debian, but the logic applies to RHEL/Rocky with minimal adjustments (swap apt for yum or dnf). Adapt commands as appropriate for your distribution.

1. System Preparation

$ sudo apt update && sudo apt upgrade -y$ apt install curl wget unzip gnupg2 openjdk-21-jdk -y

• No need to set JAVA_HOME; Artifactory 7.104+ auto-detects the bundled JDK.

2. Install & Configure PostgreSQL

$ sudo apt install postgresql postgresql-contrib -y

$ sudo -u postgres psql-- inside postgres shell, run:CREATE DATABASE artifactory;CREATE USER artifactory WITH PASSWORD 'StrongPassword';GRANT ALL PRIVILEGES ON DATABASE artifactory TO artifactory;\q

Replace 'StrongPassword' with a secure password. For external DB access, allow it in pg_hba.conf.

If logged in as the postgres Linux user:
psql -d artifactory

-- Allow artifactory user to use the schema:
GRANT ALL ON SCHEMA public TO artifactory;

-- Optionally, transfer schema ownership (recommended for new/single-tenant DBs):
ALTER SCHEMA public OWNER TO artifactory;

-- Allow artifactory user to manipulate all tables, sequences, and functions now and in the future:
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO artifactory;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO artifactory;
GRANT ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA public TO artifactory;

-- (Optional, ensures future objects auto-grant privileges)
ALTER DEFAULT PRIVILEGES IN SCHEMA public
  GRANT ALL ON TABLES TO artifactory;
ALTER DEFAULT PRIVILEGES IN SCHEMA public
  GRANT ALL ON SEQUENCES TO artifactory;
ALTER DEFAULT PRIVILEGES IN SCHEMA public
  GRANT ALL ON FUNCTIONS TO artifactory;
  
After running the above SQL, you can test as the artifactory user:
psql -h localhost -U artifactory -d artifactory

CREATE TABLE test_perm(id INT);
DROP TABLE test_perm;

If logged in as the postgres Linux user:
psql -d artifactory

-- Allow artifactory user to use the schema:
GRANT ALL ON SCHEMA public TO artifactory;

-- Optionally, transfer schema ownership (recommended for new/single-tenant DBs):
ALTER SCHEMA public OWNER TO artifactory;

-- Allow artifactory user to manipulate all tables, sequences, and functions now and in the future:
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO artifactory;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO artifactory;
GRANT ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA public TO artifactory;

-- (Optional, ensures future objects auto-grant privileges)
ALTER DEFAULT PRIVILEGES IN SCHEMA public
  GRANT ALL ON TABLES TO artifactory;
ALTER DEFAULT PRIVILEGES IN SCHEMA public
  GRANT ALL ON SEQUENCES TO artifactory;
ALTER DEFAULT PRIVILEGES IN SCHEMA public
  GRANT ALL ON FUNCTIONS TO artifactory;
  
After running the above SQL, you can test as the artifactory user:
psql -h localhost -U artifactory -d artifactory

CREATE TABLE test_perm(id INT);
DROP TABLE test_perm;

3. Download Artifactory 7.117.7

bashexport JFROG_HOME=/opt/jfrog
sudo mkdir -p $JFROG_HOME && cd $JFROG_HOME
wget https://releases.jfrog.io/artifactory/artifactory-pro/org/artifactory/pro/jfrog-artifactory-pro-7.117.7-linux.tar.gz
tar -xvf jfrog-artifactory-pro-7.117.7-linux.tar.gz
mv artifactory-pro-7.117.7 artifactory

4. Configure Artifactory for PostgreSQL

bashcp $JFROG_HOME/artifactory/var/etc/system.full-template.yaml $JFROG_HOME/artifactory/var/etc/system.yaml

• Edit $JFROG_HOME/artifactory/var/etc/system.yaml and ensure:

textshared:
  database:
    type: postgresql
    driver: org.postgresql.Driver
    url: "jdbc:postgresql://localhost:5432/artifactory"
    username: artifactory
    password: StrongPassword

Adjust hostname, username, and password as set above.

5. Download PostgreSQL JDBC Driver

$ wget -O $JFROG_HOME/artifactory/var/bootstrap/artifactory/tomcat/lib/postgresql.jar https://jdbc.postgresql.org/download/postgresql-42.7.3.jar

6. Start Artifactory

$ cd $JFROG_HOME/artifactory./app/bin/artifactoryctl start$ tail -f $JFROG_HOME/artifactory/var/log/console.log

• Monitor logs to confirm successful startup.

7. Access the Artifactory Web UI

• URL:
  http://<server_ip>:8082/
• Steps:
  • Complete the setup wizard (set administrator password)
  • Upload your license
  • Configure first repository

Additional Production Recommendations

• Run PostgreSQL and Artifactory on separate VMs for best performance.
• Use SSD storage for both binaries and database.
• Open firewalls for port 8082/tcp as needed.
• Enable server backup and configure SSL before internet exposure.
• Automate startup: Set up Artifactory as a systemd service for resilience.

You now have a modern, secure, and production-ready Artifactory 7.117.7 instance, integrated with PostgreSQL, on Linux!

Old method

Here is the complete step-by-step guide with commands to install JFrog Artifactory v7.117.7 on a Linux server with PostgreSQL as the database:

✅ 1️⃣ Prerequisites

• Linux server (RHEL/CentOS 8+, Ubuntu 20.04+/Debian 10+)
• Root or sudo access
• Minimum 4 CPU cores, 8 GB RAM, 100 GB SSD

✅ 2️⃣ Install PostgreSQL

🔹 On RHEL/CentOS:

sudo yum install -y postgresql-server postgresql-contrib
sudo postgresql-setup initdb
sudo systemctl enable postgresql
sudo systemctl start postgresql

🔹 On Ubuntu/Debian:

sudo apt update
sudo apt install -y postgresql postgresql-contrib
sudo systemctl enable postgresql
sudo systemctl start postgresql

✅ 3️⃣ Configure PostgreSQL for Artifactory

sudo -u postgres psql

Inside the PostgreSQL shell, run:

CREATE DATABASE artifactory WITH ENCODING UTF8;
CREATE USER artifactory WITH PASSWORD 'StrongPassword123!';
GRANT ALL PRIVILEGES ON DATABASE artifactory TO artifactory;
\q
Code language: JavaScript (javascript)

✅ 4️⃣ Download Artifactory 7.117.7

🔹 For RHEL/CentOS:

wget https://releases.jfrog.io/artifactory/artifactory-pro/rpm/jfrog-artifactory-pro-7.117.7.rpm
sudo yum install -y jfrog-artifactory-pro-7.117.7.rpm
Code language: JavaScript (javascript)

🔹 For Ubuntu/Debian:

wget https://releases.jfrog.io/artifactory/artifactory-pro/deb/jfrog-artifactory-pro-7.117.7.deb
sudo apt install -y ./jfrog-artifactory-pro-7.117.7.deb
Code language: JavaScript (javascript)

✅ 5️⃣ Configure Artifactory to Use PostgreSQL

Edit the system.yaml file:

sudo vi /opt/jfrog/artifactory/var/etc/system.yaml
Code language: JavaScript (javascript)

Add the database configuration:

shared:
  database:
    type: postgresql
    driver: org.postgresql.Driver
    url: jdbc:postgresql://localhost:5432/artifactory
    username: artifactory
    password: StrongPassword123!
Code language: JavaScript (javascript)

Save and exit.

✅ 6️⃣ Start and Enable Artifactory

sudo systemctl enable artifactory
sudo systemctl start artifactory

Check if the service is running:

sudo systemctl status artifactory

✅ 7️⃣ Access Artifactory Web UI

Open a browser and go to:

http://<your-server-ip>:8082
Code language: JavaScript (javascript)

• Default User: admin
• Default Password: password (you will be asked to change it on first login).

✅ 8️⃣ Check Logs

tail -f /opt/jfrog/artifactory/var/log/console.log
Code language: JavaScript (javascript)

✅ 9️⃣ (Optional) Open Firewall Ports

sudo firewall-cmd --add-port=8082/tcp --permanent
sudo firewall-cmd --reload

✅ Installation Summary

✔ Install and configure PostgreSQL
✔ Create database and user for Artifactory
✔ Install Artifactory v7.117.7 package
✔ Configure system.yaml with PostgreSQL connection
✔ Start service and access via http://<server-ip>:8082

Bash Script to Install Artifactory

Rajesh Kumar

I’m Rajesh Kumar, a DevOps, SRE, DevSecOps, Cloud, and Platform Engineering expert passionate about sharing practical knowledge, real-world experiences, and industry best practices. I have worked at Cotocus and regularly write about technology, travel, investing, health, product reviews, and digital marketing through my various platforms.

I publish technical articles at DevOps School, travel stories at Holiday Landmark, stock market insights at Stocks Mantra, health and fitness guidance at My Medic Plus, product reviews at TrueReviewNow, and SEO and digital marketing strategies at Wizbrand.