Selasa, 27 Mei 2008

postgresql

*change /etc/postgresql/8.2/main/pg_hba.conf

add/change:
# TYPE DATABASE USER CIDR-ADDRESS METHOD
host all all 192.168.11.0/24 md5

*restart postgresql

$ sudo /etc/init.d/postgresql-8.2 restart
or
$ sudo /etc/init.d/postgresql-8.2 stop
$ sudo /etc/init.d/postgresql-8.2 start

* note: thats solve problem with postgresql ident problem.
thanks to: http://www.depesz.com/index.php/2007/10/04/ident/

Tidak ada komentar: