In this tutorial, we will show you how to install phpPgAdmin and configure it to connect to your existing PostgreSQL instance.
If you haven't installed PostgreSQL yet, you can find detailed step-by-step instructions in our tutorial on running a PostgreSQL instance. It is important that you enable remote connections for PostgreSQL, so you can connect to the PostgreSQL server through phpPgAdmin.
Once you have PostgreSQL up and running, you will need to download phpPgAdmin. You can do it from their GitHub page.
You will need to upload the archive to your account and extract it. Then, you will need to update the /conf/config.inc.php file. You will need to modify these lines:
$conf['servers'][0]['host'] = '';$conf['servers'][0]['port'] = '5432';
You will need to set them to:
$conf['servers'][0]['host'] = 'localhost';$conf['servers'][0]['port'] = 'the port of your PostgreSQL WebApp';
You will be able to use the File Manager section of the hosting Control Panel to upload the installation archive, extract it, and edit the configuration file.
That's it. You will now be able to navigate to the URL of phpPgAdmin and log in with your PostgreSQL username and password.