![nixsky[www.nixsky.com]](/templets/images/toplogo.gif)
七、配置postgresql
#vi /var/postgresql/data/pg_hba.conf
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local postgres all trust
# IPv4 local connections:
host all all 0.0.0.0 0.0.0.0 md5 * 密码认证
#vi /var/postgresql/data/postgresql.conf
改:
CODE:
#listen_addresses = 'localhost'
#port = 5432
#unix_socket_permissions = 0777
#authentication_timeout = 60
#password_encryption = on
#db_user_namespace = off
为:
listen_addresses = '*'
port = 5432
unix_socket_permissions = 0700
authentication_timeout = 60
password_encryption = on
db_user_namespace = off
:wq #port = 5432
#unix_socket_permissions = 0777
#authentication_timeout = 60
#password_encryption = on
#db_user_namespace = off
为:
listen_addresses = '*'
port = 5432
unix_socket_permissions = 0700
authentication_timeout = 60
password_encryption = on
db_user_namespace = off
八、安装并配置phpPgAdmin-4.0.1
#pkg_add -r php5-pgsql-5.1.4.tgz
#/usr/local/sbin/phpxs -a pgsql
网上下载phpPgAdmin-4.0.1.tar.gz 到 /var/www/htdocs
#tar zxf phpPgAdmin-4.0.1.tar.gz
#mv phpPgAdmin-4.0.1 pgadmin
*改个容易记住的名字，当然你喜欢长文件名不改也行~_~
#vi /var/www/htdocs/pgadmin/conf/config.inc.php
CODE:
改:
$conf['servers'][0]['host'] = '';
$conf['servers'][0]['defaultdb'] = 'Template1';
$conf['extra_login_security'] = true;
为：
$conf['servers'][0]['host'] = 'localhost';
* 指定postgresql 在本机
$conf['servers'][0]['defaultdb'] = 'posrgres';
* PostgreSQL 8.1 以上版本,你需要到将这项设定为 'postgres'
$conf['extra_login_security'] = false;
*启用密码认证
:wq $conf['servers'][0]['host'] = '';
$conf['servers'][0]['defaultdb'] = 'Template1';
$conf['extra_login_security'] = true;
为：
$conf['servers'][0]['host'] = 'localhost';
* 指定postgresql 在本机
$conf['servers'][0]['defaultdb'] = 'posrgres';
* PostgreSQL 8.1 以上版本,你需要到将这项设定为 'postgres'
$conf['extra_login_security'] = false;
*启用密码认证
Power by nixsky Copyright 2004-2008