GNet Solutions » GNU/Linux Administration

This is a guide for installing phppgadmin on Debian 8 with nginx.

Prepare the Environment¶

• Make sure the system is up to date:
  

  apt-get update && apt-get upgrade -y
  

Install phppgadmin¶

• Install phppgadmin
  

  apt-get install php5-fpm php5-pgsql phppgadmin
  

• Disable apache2
  

  update-rc.d -f apache2 remove
  service apache2 stop
  

• Install nginx
  

  apt-get install nginx
  

• The installation will now complete. Now create a file to enable phppgadmin:
  

  nano /etc/nginx/sites-enabled/phppgadmin
  

  • And add the following:
    

    server {
        listen          8080;
        server_name     localhost;
    
        location / {
            root    /usr/share/phppgadmin;
            index   index.html index.htm index.php;
        }
    
        location ~ \.php$ {
            root            /usr/share/phppgadmin;
            fastcgi_pass unix:/var/run/php5-fpm.sock;
            fastcgi_index   index.php;
            fastcgi_param   SCRIPT_FILENAME  /usr/share/phppgadmin/$fastcgi_script_name;
            include         fastcgi_params;
        }
    }
    

• Edit the phppgadmin config file:
  

  nano /usr/share/phppgadmin/conf/config.inc.php
  

  • And change the extra_login_security to false
    

    $conf['extra_login_security'] = false;
    

• Now phppgadmin is accessible on the localhost from port 8080
  • NOTE: Make sure to have a password set for the postgres user

Resources¶

• https://wiki.debian.org/PhpPgAdmin