
You can install Apache from yum, or download and install Apache from source code. Install PHP and Apacheįor phpPgAdmin tool, you need to have Apache and PHP already running on your environment. Note: If you are using MySQL database on your environment, you can install phpMyAdmin to manage your MySQL database from a web console: 5 Steps to Install phpMyAdmin on Linux 1.

This tutorial explains how to install and configure phpPgAdmin tool to manage PostgreSQL from a web interface. You don’t have to worry about remembering PostgreSQL DBA commands or syntax. Using phpPgAdmin, you can pretty much do all PostgreSQL DBA activities from a web-based console.

Also, some of the DBA concepts in PostgreSQL are slightly different than MySQL. If you are MySQL DBA, you might notice that there is a slight difference in the syntax for few of the commands in PostgreSQL. If you have PostgreSQL running in your environment, managing it from command-line might be bit difficult as you have to remember all the db commands and syntax.
