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 a DevOps/SRE/DevSecOps/Cloud Expert passionate about sharing knowledge and experiences. I have worked at Cotocus. I share tech blog at DevOps School, travel stories at Holiday Landmark, stock market tips at Stocks Mantra, health and fitness guidance at My Medic Plus, product reviews at TrueReviewNow , and SEO strategies at Wizbrand.

Do you want to learn Quantum Computing?

Please find my social handles as below;

Rajesh Kumar Personal Website
Rajesh Kumar at YOUTUBE
Rajesh Kumar at INSTAGRAM
Rajesh Kumar at X
Rajesh Kumar at FACEBOOK
Rajesh Kumar at LINKEDIN
Rajesh Kumar at WIZBRAND

Rajesh Kumar DailyLogs