MYHOSPITALNOW.COM

Find Trusted Doctors & Hospitals

Discover healthcare providers, compare hospitals, and explore treatment options worldwide.

Free Treatment Quotes • Doctor Search • Hospital Comparison

Find Healthcare Options

www.myhospitalnow.com

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;

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

Find Trusted Cardiac Hospitals

Compare heart hospitals by city and services โ€” all in one place.

Explore Hospitals
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.

Related Posts

Deploying Nexus Certificate Manager (CM) and Protocol Gateway (PGWY) on Kubernetes

Step-by-step tutorial, written from an actual deployment of Certificate Manager 8.15.1-1 (CF server image 8.15.1-1, PGW image 8.15.1-1) on a 2-node kubeadm cluster. Status of this document (2026-11-12) Steps 1-8 were executed…

Read More

OpenShift Lab 9: Work with Databases in the OpenShift Web Console

Lab Goal In this lab, you will deploy a PostgreSQL database on OpenShift Local using the OpenShift web console. You will create the database using modern OpenShift…

Read More

OpenShift Lab 8: Work with Databases in OpenShift Using the oc CLI Tool

Lab Objective In this lab, you will deploy a PostgreSQL database in OpenShift using the oc CLI tool. You will learn how to: Important Concept A database…

Read More

Staff Database Platform Engineer: Role Blueprint, Responsibilities, Skills, KPIs, and Career Path

A Staff Database Platform Engineer is a senior individual contributor (IC) responsible for designing, building, and operating the companyโ€™s database platform as a productโ€”balancing reliability, performance, security, and developer self-service. The role ensures that application teams can safely and efficiently store, query, and scale data using standardized patterns, paved roads, and automated operational controls.

Read More

Senior Database Platform Engineer: Role Blueprint, Responsibilities, Skills, KPIs, and Career Path

The Senior Database Platform Engineer designs, builds, and operates the database platforms that underpin critical product and internal workloads, with a focus on reliability, performance, security, and scalable operations. This role sits in the Data Infrastructure department and blends hands-on engineering with platform thinking: enabling application teams to consume databases safely and efficiently through self-service, automation, and clear operational guardrails.

Read More

Principal Database Platform Engineer: Role Blueprint, Responsibilities, Skills, KPIs, and Career Path

The **Principal Database Platform Engineer** is a senior individual contributor (IC) responsible for the architecture, reliability, scalability, security, and cost efficiency of the organizationโ€™s database platforms. The role builds and evolves โ€œdatabase as a platformโ€ capabilitiesโ€”standardized, automated, observable, and governed database services that enable product engineering teams to ship features safely without becoming database experts.

Read More
Subscribe
Notify of
guest
1 Comment
Newest
Oldest Most Voted
Jason Mitchell
Jason Mitchell
8 months ago

Thanks for this detailed guide on installing JFrog Artifactory 7 with PostgreSQL! ๐Ÿ“ฆ The step-by-step instructions make it much easier to follow, especially for those setting it up for the first time. Very helpful โ€” appreciate you sharing this!

1
0
Would love your thoughts, please comment.x
()
x