Project

General

Profile

Support #608

Install phppgadmin on Debian

Added by Daniel Curtis over 5 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Database Server
Target version:
Start date:
04/28/2015
Due date:
% Done:

100%

Estimated time:
1.00 h
Spent time:

Description

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

History

#1 Updated by Daniel Curtis over 5 years ago

  • Description updated (diff)

#2 Updated by Daniel Curtis over 5 years ago

  • Description updated (diff)
  • Status changed from New to In Progress
  • % Done changed from 0 to 50
  • Estimated time set to 1.00

#3 Updated by Daniel Curtis over 5 years ago

  • Description updated (diff)

#4 Updated by Daniel Curtis over 5 years ago

  • Description updated (diff)

#5 Updated by Daniel Curtis over 5 years ago

  • Status changed from In Progress to Resolved
  • % Done changed from 50 to 100

#6 Updated by Daniel Curtis over 5 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF