phppgadmin is installed in /usr/share/phppgadmin. You will need to create a site file in /etc/apache2/sites-available and enable it in order to access phppgadmin. You will also have to set up dns accordingly. The file should look something like this
<VirtualHost> *:80>
ServerName pgadmin.caa.intrasec.net Redirect "/"
https://pgadmin.caa.intrasec.net
</VirtualHost>
<IfModule mod_ssl.c>
<VirtualHost _default_:443>
Servername pgadmin.caa.intrasec.net
ServerAdmin tim@jtek.co.uk
DocumentRoot /usr/share/phppgadmin
ErrorLog ${APACHE_LOG_DIR}/error.log
CustomLog ${APACHE_LOG_DIR}/access.log combined
SSLEngine on
SSLCertificateFile /etc/ssl/certs/mail-caa.pem
SSLCertificateKeyFile /etc/ssl/private/mail-caa.key
<FilesMatch "\.(cgi|shtml|phtml|php)$">
SSLOptions +StdEnvVars
</FilesMatch>
<Directory /usr/lib/cgi-bin>
SSLOptions +StdEnvVars
DirectoryIndex index.php index.html
AllowOverride None
Require all granted
AcceptPathInfo On
</Directory>
<Location "/">
Require all granted
</Location>
BrowserMatch "MSIE [2-6]" \ nokeepalive ssl-unclean-shutdown \ downgrade-1.0 force-response-1.0
BrowserMatch "MSIE [17-9]" ssl-unclean-shutdown
</VirtualHost>
</IfModule>
You will need to change the server name, SSLCertificateFile, SSLCertificateKeyFile and Redirect to match your configuration.
Don’t forget that the file name needs to end in “.conf” otherwise the “a2ensite” script will not work. If you installed the Debian packaged version then you will also need to disable the phppgadmin conf that it automatically creates:
#a2disconf phppgadmin
You might want to create a superuser that can log on to phppgadmin. To do so run
#createuser NewUserName -U postgres -DRsP
Note that for security reasons phppgadmin expressly forbids the built in postgres user from logging on.

Recent Comments