預設存取權(Privileges)
發表於 : 2010-08-23 23:09:15
from http://sites.google.com/site/mammoth/in ... privileges
1. postgresql.conf
1. listen_addresses = '*'
2. pg_hdb.conf
1. host all all 127.0.0.1/32 md5
host all powersoft 0.0.0.0/0 md5
3. sudo su postgres
1. $createuser
4. psql
1. ALTER USER powersoft PASSWORD '123';
1. postgresql.conf
1. listen_addresses = '*'
2. pg_hdb.conf
1. host all all 127.0.0.1/32 md5
host all powersoft 0.0.0.0/0 md5
3. sudo su postgres
1. $createuser
4. psql
1. ALTER USER powersoft PASSWORD '123';