4WebHelp: Installing phpPgAdmin

Preamble:

This article will show you how to install the latest version of phpPgAdmin (currently 2.3) which allows you easier maintenance of your database.

Requirements:

To begin:

Unzip the downloaded archive to a folder on your computer. Decide what you are going to call the folder, and rename it. I am not going to suggest a name for reasons of security - giving the folder an odd name is the first line of defence against malicious hackers.

Open config.inc.php in your text editor. On line 11 you will find $cfgDefaultDB    "template1";
Alter this to read $cfgDefaultDB    "dbname";

The next thing you need to edit is the following:

$cfgServers[1]['local']        = true;
$cfgServers[1]['host']        = 'localhost';
$cfgServers[1]['port']        = '5432';
$cfgServers[1]['adv_auth']     = true;
$cfgServers[1]['stduser']     = '';
$cfgServers[1]['stdpass']     = '';
$cfgServers[1]['user']         = '';
$cfgServers[1]['password']     = '';
$cfgServers[1]['only_db']     = '';

to look like:

$cfgServers[1]['local']        = false;
$cfgServers[1]['host']        = 'address.of.your.sql.server';
$cfgServers[1]['port']        = '5432';
$cfgServers[1]['adv_auth']     = false;
$cfgServers[1]['stduser']     = '';
$cfgServers[1]['stdpass']     = '';
$cfgServers[1]['user']         = 'username';
$cfgServers[1]['password']     = 'password';
$cfgServers[1]['only_db']     = 'dbname';

Note: You may have to set the port number to somethin different: check the details supplied by Freedom2surf.
Leaving only_db blank will not allow you to view everyone's databases - it will just slow down phpPgAdmin so that it is impossible to use.

I have also found it useful to set $cfgMaxText to 0 - while it slows browsing the database slightly, it does allow you to see the full contents of any text field. Non-English speaking people will also want to change the language preference at the bottom of the file.

Save the changes, and then upload the folder to the server. Point your browser to it and check that everything works. I now suggest that you follow the Password Protecting My Site tutorial and protect the directory. That way no-one else can play with your database!

© 4WebHelp and Peter

Copying and distributing this tutorial for public or commercial use without the written consent of myself is strictly prohibited.

Latest comments on this tutorial
jiya
i have downloadded phppgmyAdmin 5.0.3 and its file is xtremly different than yours ... how do i configure it Sad
Anaconda
Same Here
simselk
I've opened the config.inc.php file, however the file is different to the one above.


I have downloaded php 4.0.1, any help would be appreciated.

thanks
sudhir
same here ....
jo luso
I have installed phpPGAdmin on debian. My silly question is: how do I access it?

I can't find an answer to this simple question.
Shiznit
oo yeaa

Add a new comment


Page URL: http://www.4webhelp.net/tutorials/db/phppgadmin.php
Back to the "pretty" page!

© 2017, 4WebHelp Team.