How to Install pgAdmin on CentOS 7

Install pgAdmin on CentOS 7

In this article, we will have explained the necessary steps to install and configure pgAdmin on CentOS 7. Before continuing with this tutorial, make sure you are logged in as a user with sudo privileges. All the commands in this tutorial should be run as a non-root user.

pgAdmin is the leading open-source feature-rich PostgreSQL administration and development platform that runs on Linux, Unix, MacOS, and Windows. pgAdmin can be used to manage PostgreSQL 9.2 and above.

Install pgAdmin on CentOS

Step 1. The first command will update the package lists to ensure you get the latest version and dependencies.

sudo yum install epel-release
sudo yum update

Step 2. Install PostgreSQL.

Go to the PostgreSQL repository download page, and add the PostgreSQL 9.4 repository:

rpm -Uvh https://download.postgresql.org/pub/repos/yum/testing/12/redhat/rhel-7-x86_64/pgdg-centos12-12-1.noarch.rpm

Now, Install postgresql with the following command:

yum update
yum install postgresql94-server postgresql94-contrib

Initialize postgresql database using following command:

/usr/pgsql-9.4/bin/postgresql94-setup initdb

To start PostgreSQL service, run:

systemctl enable postgresql-9.4
systemctl start postgresql-9.4

Step 3. Install pgAdmin 4 on CentOS 7.

Once you have PostgreSQL installed on your system, run the following command to install pgAdmin 4:

yum install epel-release
yum update

Now, Install phpPgAdmin, enter the following command:

yum install phpPgAdmin httpd

Step 4. Configure pgAdmin.

There are few minor configuration changes that need to be done to have pgAdmin4 running. First we will rename the sample conf file from pgadmin4.conf.sample to pgadmin4.conf:

cp /etc/httpd/conf.d/pgadmin4.conf.sample /etc/httpd/conf.d/pgadmin4.conf

Next, create a pgAdmin log and data directories:

mkdir /var/log/pgadmin4/
mkdir /var/lib/pgadmin4/

Create/Edit config_local.py file:

nano /usr/lib/python2.7/site-packages/pgadmin4-web/config_local.py

Add the following settings:

LOG_FILE = '/var/log/pgadmin4/pgadmin4.log'
SQLITE_PATH = '/var/lib/pgadmin4/pgadmin4.db'
SESSION_DB_PATH = '/var/lib/pgadmin4/sessions'
STORAGE_DIR = '/var/lib/pgadmin4/storage'

Change permissions of directories so that Apache:

chown -R apache:apache /var/lib/pgadmin4/*
chown -R apache:apache /var/log/pgadmin4/*

Run the following command to create a user account for the pgAdmin 4 web interface.

python /usr/lib/python2.7/site-packages/pgadmin4-web/setup.py

Finally steps, Restart the Apache web service:

systemctl restart httpd

Step 5. Configure Firewall.

If the Firewall is enabled, execute the following command to enable http service:

firewall-cmd --permanent --add-service=http
firewall-cmd --reload

Step 6. Access pgAdmin 4.

Open a web browser and go to the following URL to access the pgAdmin 4 interface:

http://my-ip.add.re.ss/pgadmin4

Congratulation, you have learned how to install and configure pgAdmin 4 on CentOS 7. If you have any questions, please leave a comment below.