Install and configure phppgAdmin on Ubuntu

I always wanted to deploy phppgamdin, But I encountered different problems when installing phppgamdin in RedHat and Windows. Because I am not familiar with the web stuff, I finally ended up failing. For details, see:

On the weekend, I was suddenly interested. I installed Ubuntu and tried phppgAdmin again last night. Finally, the configuration was successful. Record process:

1. Install php5, apache2, and postgresql8.4.2 using the new software package manager provided by Ubuntu.

2. After the installation is complete, test apache2 and enter http: // localhost in the browser to display It's works ..

3. for convenience, run cp/usr/share/phppgadmin/var/www directly, copy the phppgadmin directory to the default directory of apache2, and then enter/var/www to delete index.html.

4. Enter/var/www/conf, modify the config. inc. php file, and change the following configuration item from true to false.

1. // If extra login security is true, then logins via phpPgAdmin with no
2. // Password or certain usernames (pgsql, postgres, root, administrator)
3. // Will be denied. Only set this false once you have read the FAQ and
4. // Understand how to change PostgreSQL's pg_assist.conf to enable
5. // Passworded local connections.
6. $ Conf ['extra _ login_security '] = false;

5. For more information about how to enable the postgre listener, see the previous blog.

6. restart apache2 and run service apache2 restart.

7. Enter the locathost or local IP address in the browser. The next thing is the same as going to the CSDN forum. No more.

8. As the saying goes, there is a picture and a real image. capture a few posts to play with it:

A. Overall View:

B. Execute the SQL statement:

C. Interface for creating functions or stored procedures:

1 2 Next Page