How to install phpPgAdmin on CentOS 7

Instructions for installing phpPgAdmin on CentOS 7 with just a few steps.

I. Introduction

What is phpPgAdmin?

phpPgAdmin is a great tool designed specifically for the PostgreSQL database management system. If you do not know about PostgreSQL, you can refer to the tutorial below.

• How to install PostgreSQL on CentOS 7

phpPgAdmin is a web-based database management tool dedicated to the PostgreSQL database management system. phpPgAdmin is a web-based database management tool dedicated to the PostgreSQL database management system.

phpPgAdmin works well on most basic web servers: Apache, Nginx, etc. It offers a variety and convenience in database management through an intuitive interface.

Main functions:

• Administer multiple servers
• Support for PostgreSQL 8.4.x, 9.x, 10.x, 11.x
• Manage all aspects of:
  • Users & groups
  • Databases
  • Schemas
  • Tables, indexes, constraints, triggers, rules & privileges
  • Views, sequences & functions
  • Advanced objects
  • Reports
• Easy data manipulation:
  • Browse tables, views & reports
  • Execute arbitrary SQL
  • Select, insert, update and delete
• Dump table data in a variety of formats: SQL, COPY, XML, XHTML, CSV, Tabbed, pg_dump
• Import SQL scripts, COPY data, XML, CSV and Tabbed
• Supports the Slony master-slave replication engine
• Excellent language support:
  • Available in 27 languages
  • No encoding conflicts. Edit Russian data using a Japanese interface!
• Easy to install and configure
• Extendable with the use of plugins.

Installation conditions:

To be able to install phpPgAdmin, your server needs to meet the following:

• Web Service NGINX or Apache.
• PHP 5.6 or later and the php-pgsql extension enabled on the server side.
• PostgreSQL 8.4.x, 9.x, 10.x, 11.x…

II. Implementation Guide

To install phpPgAdmin, you can do it with the following 4 steps.

Step 1: SSH into your VPS

To install PostgreSQL, we first need to SSH or access your VPS/server as root. If you don’t know how to SSH into your VPS/Server, you can refer to the following tutorial:

• How to login to Linux VPS with SSH protocol.

After successful SSH, we continue with step 2 to Download phpPgAdmin

Bước 2: Download

• Download phpPgAdmin

At the time of writing, the latest version of phpPgAdmin is phpPgAdmin 7.12.0, so I will download this version, if you have a newer version at the time of installation, you can try it.

You can quickly download the source code through the following command:

wget https://github.com/phppgadmin/phppgadmin/archive/REL_7-12-1.tar.gz
    

• Extract the downloaded file:

tar -xvf REL_7-12-1.tar.gz
    

• After extracting the file, move the extracted folder data to the path /usr/share/phppgadmin

mv phppgadmin-REL_7-12-1 /usr/share/phppgadmin
    

• Assign permissions by the user with the command:

chown -R nginx:nginx /usr/share/phppgadmin     (Đối với Nginx)
hoặc
chown -R apache:apache /usr/share/phppgadmin   (Đối với Apache)
    

Step 3: Configure phpPgAdmin

• Before changing the configuration file, you should back it up first with the command:

cd /usr/share/phppgadmin/conf/
cp config.inc.php-dist config.inc.php
    

• Edit the config.inc.php file:

vi  config.inc.php
    

You find and edit the following content:

//Hostname hoặc IP của Server
$conf['servers'][0]['host'] = 'localhost';
//Database port on server (5432 is the PostgreSQL default)
$conf['servers'][0]['port'] = 5432;
// If extra login security is true, then logins via phpPgAdmin with no
// password or certain usernames (pgsql, postgres, root, administrator)
// will be denied.
$conf['extra_login_security'] = true;
// Only show owned databases? 
$conf['owned_only'] = false;

• Web Server Configuration
  • With a server using Apache

vi /etc/httpd/conf.d/phppgadmin.conf
    

You add the content below:

Alias /phppgadmin "/usr/share/webapps/phppgadmin"

  DirectoryIndex index.php     
  AllowOverride All     
  Options FollowSymlinks     
  Require all granted
  # phppgadmin raises deprecated warnings that lead
     
  # to parsing errors in JS     
  php_flag display_startup_errors off     
  php_flag display_errors off     
  php_flag html_errors off

Restart the webserver with the command:

systemctl restart httpd
    

• With a server using Nginx

vi /etc/nginx/conf.d/your-domain.conf
    

location  /phppgadmin{
                 root /usr/share/;
                 index index.php index.html index.htm;
                 location ~ ^/phppgadmin/(.+.php)$ {
                         try_files $uri =404;
                         root /usr/share/;
                         fastcgi_pass unix:/var/run/php-fpm/php-fpm.sock;
                         fastcgi_index index.php;
                         fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
                         include /etc/nginx/fastcgi_params;
                 }
location ~* ^/phppgadmin/(.+.(jpg|jpeg|gif|css|png|js|ico|html|xml|txt))$ {
                         root /usr/share/;
                 }
}
         location /phpPgAdmin {
                rewrite ^/* /phppgadmin last;
         }

Restart the webserver:

systemctl restart nginx
    

Step 4: Check the operation of phpPgAdmin

After the installation is complete, we proceed to recheck by opening the browser and accessing the path: http://domain.com/phppgadmin. If the screen shows as shown, you have succeeded.

III. Summary

Thus, in this article, AZDIGI showed you how to quickly install phpPgAdmin on CentOS 7. Installing phpPgAdmin will make your PostgreSQL database administration simpler and easier.

If you find the article helpful, please share it widely. Wishing you success.

In addition, you can refer to some other articles on Linux knowledge at the link below:

• General Guide to Linux

If you need assistance, you can contact support in the ways below:

• Hotline 247: 028 888 24768 (Ext 0)
• Ticket/Email: You use the email to register for the service and send it directly to: support@azdigi.com