{"id":12372,"date":"2019-03-26T21:52:11","date_gmt":"2019-03-26T21:52:11","guid":{"rendered":"http:\/\/www.appservgrid.com\/paw92\/?p=12372"},"modified":"2019-03-26T21:52:11","modified_gmt":"2019-03-26T21:52:11","slug":"how-to-install-pgadmin4-in-centos-7","status":"publish","type":"post","link":"https:\/\/www.appservgrid.com\/paw92\/index.php\/2019\/03\/26\/how-to-install-pgadmin4-in-centos-7\/","title":{"rendered":"How to Install pgAdmin4 in CentOS 7"},"content":{"rendered":"

PgAdmin4<\/strong>\u00a0is a easy to use web interface for managing PostgreSQL databases. It can be used on multiple platforms such as Linux, Windows and Mac OS X. In pgAdmin 4 there is migration from bootstrap 3 to bootstrap 4.<\/p>\n

In this tutorial we are going to install\u00a0pgAdmin 4<\/strong>\u00a0on a\u00a0CentOS 7<\/strong>\u00a0system.<\/p>\n

Note<\/strong>: This tutorial assumes that you already have PostgreSQL 9.2 or above installed on your CentOS 7. For instructions how to install it, you can follow our guide:\u00a0How to install PostgreSQL 10 on CentOS and Fedora<\/a>.<\/p>\n

How to Install pgAdmin 4 in CentOS 7<\/h3>\n

This step should have been completed upon the installation of PostgreSQL, but if you haven\u2019t, you can complete it with:<\/p>\n

# yum -y install https:\/\/download.postgresql.org\/pub\/repos\/yum\/11\/redhat\/rhel-7-x86_64\/pgdg-centos11-11-2.noarch.rpm\r\n<\/pre>\n
Now you are ready to install pgAdmin with:<\/center><\/p>\n
# yum -y install pgadmin4\r\n<\/pre>\n
During the installation, due to dependencies, the following two will be installed as well \u2013\u00a0pgadmin4-web<\/strong>\u00a0and\u00a0httpd web server<\/strong>.<\/p>\n
How to Configure pgAdmin 4 in CentOS 7<\/h3>\n
There are few minor configuration changes that need to be done to have\u00a0pgAdmin4<\/strong>\u00a0running. First we will rename the sample conf file from\u00a0pgadmin4.conf.sample<\/strong>\u00a0to\u00a0pgadmin4.conf<\/strong>:<\/p>\n
# mv \/etc\/httpd\/conf.d\/pgadmin4.conf.sample \/etc\/httpd\/conf.d\/pgadmin4.conf\r\n<\/pre>\n
Adjust the file so it looks like this:<\/p>\n
<VirtualHost *:80>\r\nLoadModule wsgi_module modules\/mod_wsgi.so\r\nWSGIDaemonProcess pgadmin processes=1 threads=25\r\nWSGIScriptAlias \/pgadmin4 \/usr\/lib\/python2.7\/site-packages\/pgadmin4-web\/pgAdmin4.wsgi\r\n\r\n<Directory \/usr\/lib\/python2.7\/site-packages\/pgadmin4-web\/>\r\n        WSGIProcessGroup pgadmin\r\n        WSGIApplicationGroup %{GLOBAL}\r\n        <IfModule mod_authz_core.c>\r\n                # Apache 2.4\r\n                Require all granted\r\n        <\/IfModule>\r\n        <IfModule !mod_authz_core.c>\r\n                # Apache 2.2\r\n                Order Deny,Allow\r\n                Deny from All\r\n                Allow from 127.0.0.1\r\n                Allow from ::1\r\n        <\/IfModule>\r\n<\/Directory>\r\n<\/VirtualHost>\r\n<\/pre>\n
Next we will create logs and lib directories for\u00a0pgAdmin4<\/strong>\u00a0and set their ownership:<\/p>\n
# mkdir -p \/var\/lib\/pgadmin4\/\r\n# mkdir -p \/var\/log\/pgadmin4\/\r\n# chown -R apache:apache \/var\/lib\/pgadmin4\r\n# chown -R apache:apache \/var\/log\/pgadmin4\r\n<\/pre>\n
And then we can extend the contents of our\u00a0config_distro.py<\/strong>.<\/p>\n
# vi \/usr\/lib\/python2.7\/site-packages\/pgadmin4-web\/config_distro.py\r\n<\/pre>\n
And add the following lines:<\/p>\n
LOG_FILE = '\/var\/log\/pgadmin4\/pgadmin4.log'\r\nSQLITE_PATH = '\/var\/lib\/pgadmin4\/pgadmin4.db'\r\nSESSION_DB_PATH = '\/var\/lib\/pgadmin4\/sessions'\r\nSTORAGE_DIR = '\/var\/lib\/pgadmin4\/storage'\r\n<\/pre>\n
Finally we will create our user account, with which we will authenticate in the web interface. To do this, run:<\/p>\n
# python \/usr\/lib\/python2.7\/site-packages\/pgadmin4-web\/setup.py\r\n<\/pre>\n
\n
\"Create<\/a><\/p>\n
Create PgAdmin4 User<\/p>\n<\/div>\n
Now you can access your server\u2019s\u00a0http:\/\/ip-address\/pgadmin4<\/strong>\u00a0or\u00a0http:\/\/localhost\/pgadmin4<\/strong>\u00a0to reach the pgAdmin4 interface:<\/p>\n
\n
\"PgAdmin4<\/a><\/p>\n
PgAdmin4 Login<\/p>\n<\/div>\n
To authenticate, use the email address and password that you have used earlier. Once authenticate, you should see the pgAdmin4 interface:<\/p>\n
\n
\"PgAdmin4<\/a><\/p>\n
PgAdmin4 Dashboard<\/p>\n<\/div>\n
At your first login, you will need to add a new server to manage. Click on \u201cAdd New Server<\/strong>\u201d. You will need to configure the\u00a0PostgresQL<\/strong>\u00a0connection. In the first tab \u201cGeneral<\/strong>\u201d, enter the following settings:<\/p>\n