Support #608
Updated by Daniel Curtis over 9 years ago
This is a guide for installing phppgadmin on Debian 8 with nginx.
h2. Prepare the Environment
* Make sure the system is up to date:
<pre>
apt-get update && apt-get upgrade -y
</pre>
h2. Install phppgadmin
* Install phppgadmin
<pre>
apt-get install php5-fpm php5-pgsql phppgadmin
</pre>
* Disable apache2
<pre>
update-rc.d -f apache2 remove
service apache2 stop
</pre>
* Install nginx
<pre>
apt-get install nginx
</pre>
* The installation will now complete. Now create a file to enable phppgadmin:
<pre>
nano /etc/nginx/sites-enabled/phppgadmin
</pre>
#* And add the following:
<pre>
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;
}
}
</pre>
* Edit the phppgadmin config file:
<pre>
nano /usr/share/phppgadmin/conf/config.inc.php
</pre>
#* And change the extra_login_security to false
<pre>
$conf['extra_login_security'] = false;
</pre>
* Now phppgadmin is accessible on the localhost from port 8080
#* *NOTE*: Make sure to have a password set for the postgres user
h2. Resources
* https://wiki.debian.org/PhpPgAdmin