unable to connect postgresql remote database by using pgadmin

Question

Hi all i install postgre on my localserver(ubuntu) with ip 192.168.1.10 and now try to access the database from my client machine(ubuntu) with ip 192.168.1.11 by pgadmin please guide me....actually i know i have to make changes in postgresql.conf to allow client ip and pg_hba.conf

Answer 1

If you're using PostgreSQL 8 or above, you may need to modify the listen_addresses setting in /etc/postgresql/8.4/main/postgresql.conf.

Try adding the line:

listen_addresses = *

which will tell PostgreSQL to listen for connections on all network interfaces.

If not explicitly set, this setting defaults to localhost which means it will only accept connections from the same machine.