PhpPgAdmin

From Alpine Linux

What is phpPgAdmin?

phpPgAdmin is a web-based administration tool for PostgreSQL. It is perfect for PostgreSQL DBAs, newbies and hosting services.

Set up phpPgAdmin on Alpine Linux

This document will be a very quick c/p guide to setup phpPgAdmin on Alpine linux. What we will setup is the following:

  • Lighttpd with PHP
  • postgresql
  • phpPgAdmin

Install lighttpd, PHP and postgresql

apk add lighttpd postgresql postgresql-client php-pgsql

Configuring Lighttpd

Edit lighttpd.conf

nano +46 /etc/lighttpd/lighttpd.conf

Uncomment line:

uncoment    include "mod_fastcgi.conf", save and exit

Note: If you are using the Alpine ACF, change the lighttpd port:

nano +81 /etc/lighttpd/lighttpd.conf 
uncomment and change the line to: server.port          = 8080

Starting http service and adding to boot

/etc/init.d/lighttpd start && rc-update add lighttpd default

Configuring postgresql

/etc/init.d/postgresql setup

Starting http service and adding to boot

/etc/init.d/postgresql start && rc-update add postgresql default

Installing phpPgAdmin

Install phpPgAdmin

Make webapps folder

mkdir /usr/share/webapps/ -p

Download

cd /usr/share/webapps/
wget http://downloads.sourceforge.net/phppgadmin/phpPgAdmin-4.2.3.tar.gz

Unpack and delete tar file

tar zxvf phpPgAdmin-4.2.3.tar.gz
rm phpPgAdmin-4.2.3.tar.gz

Change Folder Name

mv phpPgAdmin-4.2.3 phppgadmin

Change Config File Name

cp /usr/share/webapps/phppgadmin/conf/config.inc.php-dist /usr/share/webapps/phppgadmin/conf/config.inc.php

Change Folder Persmissions

chmod -R 777 /usr/share/webapps/

Make Symlink to the phpPgAdmin folder

ln -s /usr/share/webapps/phppgadmin/ /var/www/localhost/htdocs/phppgadmin

Log on your phpPgAdmin

Browse to: http://WEBSERVER_IP_ADDRESS/phppgadmin and logon to phpPgAdmin using postgresql user and password. And enjoy this nice and useful tool.

Note: If you are using the Alpine ACF, or if you change the port in the lighttpd.conf file, the go to the port you set. e.g: if you set the port to 8080, then browse to: http://WEBSERVER_IP_ADDRESS:8080/phppgadmin

License

phpPgAdmin License

phpPgAdmin is released under GNU General Public License.The GNU Public License