1.) Install phppgadmin
git clone git://github.com/phppgadmin/phppgadmin.git phppgadmin
2.) Create apache configuration file
nano /etc/apache2/conf-available/phppgadmin.conf Alias /phppgadmin /usr/share/phppgadmin/ <Directory /usr/share/phppgadmin/> DirectoryIndex index.php Options +FollowSymLinks AllowOverride None order deny,allow deny from all allow from 127.0.0.0/255.0.0.0 ::1/128 allow from all <IfModule mod_php5.c> php_flag magic_quotes_gpc Off php_flag track_vars On php_value include_path . </IfModule> </Directory>
3.) Copy and edit phppgadmin configuration file
cp phppgadmin/conf/config.inc.php-dist phppgadmin/conf/config.inc.php nano phppgadmin/conf/config.inc.php $conf['servers'][0]['host'] = ''; $conf['extra_login_security'] = false;
4.) Restart postgresql and apache