pgAdmin 4 : Installation steps on centOS 7
pgAdmin 4 : Installation steps on centOS 7
pgAdmin, a free and open source management tool for PostgreSQL and derivative relation databases like EDB Advanced Server. This can be installed on multiple OS platforms like Linux, Unix, Mac OS X, and Windows to manage PostgreSQL 9.2 and above.
pgAdmin can be run as both web and desktop application.
Web Deployment:
As web based application, it is deployed behind a web server running as a reverse proxy or using the WSGI interface.
Desktop Deployment:
In desktop deployment, it is deployed to run in desktop mode by utilizing the desktop run time to host the application. When the run time is launched, it runs the pgAdmin server and launches a web browser to render the user interface.
Now, we are going to see the pgAdmin 4 installation steps in CentOS 7 (Web Deployment).
Prerequisites
- Server with root login
Installing PostgreSQL Server
First, we need to enable the EPEL repository to download dependent packages for pgAdmin.
yum install https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
Set up PostgreSQL Repository (PostgreSQL 11)
pgAdmin 4 is available in PostgreSQL repository and your system should have the PostgreSQL repository by now, if you have already completed the installation of PostgreSQL. If not, add the PostgreSQL repository using the below command.
yum install https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7-x86_64/pgdg-centos11-11-2.noarch.rpm
PostgreSQL 10
yum install https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-centos10-10-2.noarch.rpm
Install pgAdmin 4
Once the PostgreSQL repository configured on your system, run the following command to install pgAdmin 4.
yum -y install pgadmin4
Now, Check you have started and enabled httpd service
systemctl start httpd systemctl enable httpd
Configure pgAdmin 4
Now, we need to do some configuration changed to access pgAdmin 4. Copy the pgAdmin 4 sample configuration.
cp /etc/httpd/conf.d/pgadmin4.conf.sample /etc/httpd/conf.d/pgadmin4.conf
Create a pgAdmin log and data directories.
mkdir /var/log/pgadmin4/ mkdir /var/lib/pgadmin4/
Now, edit config_local.py file
nano /usr/lib/python2.7/site-packages/pgadmin4-web/config_local.py
Add the below settings for log and session save path
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 can write data into it.
chown -R apache:apache /var/lib/pgadmin4/ chown -R apache:apache /var/log/pgadmin4/
To create a user account for the pgAdmin 4 web interface, run the below command.
python /usr/lib/python2.7/site-packages/pgadmin4-web/setup.py
Output
NOTE: Configuring authentication for SERVER mode. Enter the email address and password to use for the initial pgAdmin user account: Email address: admin@webhostingchennai.co.in Password:******** Retype password:******** pgAdmin 4 - Application Initialisation ======================================
Now, restart the apache service.
systemctl restart httpd
Firewall
Setup firewall, to access pgAdmin 4 from external/remote machines.
firewall-cmd --permanent --add-service=http firewall-cmd --reload
Note: Consider disabling SELinux permanently for pgAdmin 4 to work properly.
Access pgAdmin 4, from browser using the below URL
http://your_server_ip/pgadmin4

pgAdmin 4 : Installation steps on centOS 7 – pgAdmin Login
Log in to pgAdmin 4 web interface using the email address and password you have created earlier.

pgAdmin 4 : Installation steps on centOS 7 – pgAdmin Home Page
Click on Add New Server, to manage a PostgreSQL server.
In General Tab,
Name : Enter your server ip address or hostname.

pgAdmin 4 : Installation steps on centOS 7 – Adding New PostgreSQL Instance
Connection Tab:
Hostname/address:- Hostname or IP Address of PostgreSQL server
Port:- 5432 (Leave default) – Change it if required
Username:- Username by which you are connecting.
Password:- Password for the user
Make sure you have enabled the port 5432 in your server
if not enable the port using the below commands.
firewall-cmd --zone=public --permanent --add-port=5432/tcp firewall-cmd --reload

pgAdmin 4 : Installation steps on centOS 7 – PostgreSQL Instance Details
Click Save to save the changes. Now you can see the server you have added.
If you are getting Fatal: Ident authentication failed for user error, edit the below file and modify the authentication.
nano/var/lib/pgsql/11/data/pg_hba.conf
modify the file as below
# TYPE DATABASE USER ADDRESS METHOD host all all all md5
Restart the PostgreSQL service.
systemctl restart postgresql-11
OR
systemctl restart postgresql-10
Now, pgAdmin4 is installed on our sever, hope this post is helpful.
To Install PostgreSQL 11 / 10 on CentOS 7 : Click Here
Please share your valuable comments to improve us.
We’re a bunch of volunteers and starting a new
scheme in our community. Your web site offered us with valuable
info to work on. You’ve performed an impressive
process and our whole neighborhood will likely be grateful
to you.
What’s Going down i am new to this, I stumbled upon this
I have discovered It absolutely helpful and it has helped me out loads.
I’m hoping to contribute & help different users like its helped me.
Good job.
Hi! I could have sworn I’ve been to this blog before but after checking through some of the post I realized it’s
new to me. Anyways, I’m definitely glad I found it and I’ll be bookmarking and checking back
often!