UbuntuHelp:PhpPgAdmin

文章出处:

https://help.ubuntu.com/community/phpPgAdmin

点击翻译:

English

Introduction

phpPgAdmin is a web based PostgreSQL software management package. To use it you should install and configure PHP, Apache and postgresql, see PostgreSQL for instructions.

Installing From Package

Install phpPgAdmin from the Universe repository see InstallingSoftware for detailed instructions on using repositories and package managers. (Note, however, that installation from a package manager often does not work). From console:

sudo apt-get install phppgadmin

To set up under Apache all you need to do is include the following line in /etc/apache2/apache2.conf.

Include /etc/phpmyadmin/apache.conf

Once phpPgAdmin is installed point your browser to [1] to start using it. You should be able to login using any users you've setup in PostgreSQL.

Remote access

By default you can only access phppgadmin from localhost. If you want to be able to use it remotley, do the following:

sudo nano /etc/phppgadmin/apache.conf

Comment out (add # at beginning of line) "allow from 127.0.0.0/255.0.0.0 ::1/128" and remove # from the line below it, "allow from all". Then restart apache

sudo /etc/init.d/apache2 reload

Note: This guide has been tested on Ubuntu 9.10 (Karmic).

---