Purusothaman A <Purusothaman.A@xxxxxxxxx> writes: > My system IP is 192.168.2.111, and client machine IP is 192.168.2.89. > I can connect to the PostgreSQL server with " psql -Uroot -h192.168.2.111" > from same system(192.168.2.111) > If I give the above command from 192.168.2.89, results > E:\Program Files\PostgreSQL\8.1\bin>psql -Uroot - h192.168.2.111 > psql: could not connect to server: Connection refused (0x0000274D/10061) > Is the server running on host "192.168.2.111" and accepting > TCP/IP connections on port 5432? I'm betting that you have some firewall software on that server that needs to be persuaded to let through nonlocal connections to port 5432. > I have read that we have to specify option "-i" while starting postmaster to > accept TCP/IP connections from other systems. (Is it right?) No, that's been superseded by listen_addresses, which you appear to have set correctly already. (If you modified that entry, you did restart the postmaster afterwards, right?) regards, tom lane
