|
|
| 第1行： |
第1行： |
| − | {{top news}}
| + | Hey, that's a clever way of thniknig about it. |
| − | {{SeeWikipedia}}
| + | |
| − | | + | |
| − | phpPgAdmin是一个让你通过网络对你的PostgreSQL进行管理的工具，也是使用PHP语言编写，支持多国语言(含简、繁中文)等多国语言，支持PostgreSQL v7.0.x, v7.1.x, v7.2.x, v7.3.x, v7.4.x, v8.0.x and v8.1.x
| + | |
| − | | + | |
| − | ===基本功能===
| + | |
| − | 和phpmyadmin几乎一样
| + | |
| − | | + | |
| − | ==安装指南==
| + | |
| − | PHP using the --with-pgsql
| + | |
| − | | + | |
| − | 针对 Debian 用户
| + | |
| − | apt-get install php4-pgsql
| + | |
| − | apt-get install php5-pgsql
| + | |
| − | | + | |
| − | http://localhost/phpPgAdmin-4.1/
| + | |
| − | Login disallowed for security reasons.
| + | |
| − | http://phppgadmin.sourceforge.net/?page=faq
| + | |
| − | | + | |
| − | psql mydb
| + | |
| − | mydb=# create user huihoo;
| + | |
| − | mydb=# alter user huihoo with password 'huihoo';
| + | |
| − | mydb=# \d
| + | |
| − | public | cities | table | postgres
| + | |
| − | public | myview | view | postgres
| + | |
| − | public | sal_emp | table | postgres
| + | |
| − | public | weather | table | postgres
| + | |
| − | | + | |
| − | mydb=# grant all on sal_emp to huihoo;
| + | |
| − | mydb=# grant all on cities to huihoo;
| + | |
| − | mydb=# grant all on weather to huihoo;
| + | |
| − |
| + | |
| − | mydb=# \q
| + | |
| − | psql -U huihoo -d mydb
| + | |
| − |
| + | |
| − | vi /etc/postgresql/pg_hba.conf
| + | |
| − | host all all 127.0.0.1 255.255.255.255 trust
| + | |
| − | and
| + | |
| − | vi conf/config.inc.php
| + | |
| − | $conf['servers'][0]['host'] = '127.0.0.1';
| + | |
| − | $conf['extra_login_security'] = false;
| + | |
| − | | + | |
| − | /etc/init.d/postgresql restart
| + | |
| − | http://localhost/phpPgAdmin-4.1/
| + | |
| − | huihoo/huihoo
| + | |
| − | PostgreSQL 7.4.7 running on 127.0.0.1:5432 -- You are logged in as user "huihoo" :)
| + | |
| − |
| + | |
| − | ==相关链接==
| + | |
| − | | + | |
| − | *官方网站 - http://phppgadmin.sourceforge.net/
| + | |
| − | *下载 - http://phppgadmin.sourceforge.net/?page=download
| + | |
| − | | + | |
| − | ==精彩图集==
| + | |
| − | <gallery perrow=6>
| + | |
| − | Image:phppgadmin-01.png
| + | |
| − | Image:phppgadmin-02.png
| + | |
| − | Image:phppgadmin-03.png|Viewing a database
| + | |
| − | Image:phppgadmin-04.png|Exporting a database
| + | |
| − | Image:phppgadmin-05.png|Searching for database objects
| + | |
| − | Image:phppgadmin-06.png|Viewing a table's structure
| + | |
| − | </gallery>
| + | |
| − | | + | |
| − | {{Comment}}
| + | |
| − | | + | |
| − | [[Category:Database]]
| + | |
| − | [[Category:PostgreSQL]]
| + | |
| − | [[Category:PHP]]
| + | |
