How to connect to postgreSQL database through the network (linux - debian system)
# /etc/init.d/postgresql start
step:1 Allow remote access to postgresql database....
First you open the file called /etc/postgresql/pg_hba.conf.
# vim /etc/postgresql/8.1/main/pg_hba.conf
Now append the following line.
host all all ip_address net_mask auth_method
"ip_address" means your ip. "net_mask" means net mask. "auth_method" means authentication method. There are few authentication methods. such as "password, trust, md5" like that...
eg:
host all all 192.168.0.2 255.255.255.0 trust
When we add auth_method as 'trust', think as trust user. If we add as 'md5', have to issue password while connect to this machine.
more details on postgresql doc
then save and close
step:2 Allow TCP/IP communication
open the file called /etc/postgresql/8.1/main/postgresql.conf. (8.1 means version. It may be vary)Uncomment "listen_addresses" option.
It's default value is "localhost" and change to '*'.
Finally restart the postgresql database server..
# /etc/init.d/postgresql restart
step:3 Try to connect from remote machine
# psql -h 192.168.0.21 -U postgres d- test
-h means host
-U means user name
-d means database name
enjoy...........
From http://chamathg.blogspot.com/2007/08/how-to-connect-to-postgresql-database.html