phpPgAdmin is web-based client written in php for accessing and managing PostgreSQL databases. It provides very efficient way to work with databases on PostgreSQL like, create database, table, alter database, export/import database etc.
This article will help you to install phpPgAdmin on CentOS and RedHat Systems. Before installing it make sure you have Apache and PostgreSQL installed on server. If you do not have them read our tutorials to how to install them.
Step 1: Add PostgreSQL Repository
First step is to install postgres repository in your system, Download repository rpm using one of below urls.
CentOS/RHEL 5, 32-Bit: # wget http://yum.postgresql.org/9.1/redhat/rhel-5-i386/pgdg-centos91-9.1-4.noarch.rpm CentOS/RHEL 6, 32-Bit: # wget http://yum.postgresql.org/9.1/redhat/rhel-6-i386/pgdg-centos91-9.1-4.noarch.rpm CentOS/RHEL 5, 64-Bit: # wget http://yum.postgresql.org/9.1/redhat/rhel-5.0-x86_64//pgdg-centos91-9.1-4.noarch.rpm CentOS/RHEL 6, 64-Bit: # wget http://yum.postgresql.org/9.1/redhat/rhel-6.3-x86_64/pgdg-centos91-9.1-4.noarch.rpm
Step 2: Install phpPgAdmin using Yum
Install phpPgAdmin package using yum command line tool.
# yum install phpPgAdmin
Step 3: Configure phpPgAdmin to Access Remotly.
phpPgAdmin bye default all allowed to access from localhost only. If you want to make it accessible from remote computers edit /etc/httpd/conf.d/phpPgAdmin.conf and update configure like below.
Alias /phpPgAdmin /usr/share/phpPgAdmin <Directory /usr/share/phpPgAdmin> order deny,allow deny from all allow from 192.168.1.0/24 </Directory>
Step 4: Restart Apache Service
Restart Apache service to reload new settings.
# service httpd restart
Step 5: Access phpPgAdmin on Browser.
Now you can access phpPgAdmin in browser using following url. Change 192.168.1.100 with your server ip.
- Eesha Rebba Wiki, Height, Weight, Age, Affairs, Biography
- Nina Dobrev Wiki, Height, Weight, Age, Affairs, Biography
- Selfies and Photoshoots of Actress Dimple Chopade
- How to teach your Husky to sit and stay