TCP\IP remote connection

Hi All,

How to accept TCP\IP remote connections? is there any specific settings to accept connections.

Plz help!!!

Thanks
Mohit

Check out your value for listen_address:

http://www.postgresql.org/docs/8.3/static/runtime-config-connection.html#GUC-LISTEN-ADDRESSES

1) Make sure the firewall accepts incoming traffic
2) Change pg_hba.conf
3) Change postgresql.conf
4) restart your databaseserver (because of nr. 3)

And don't forget security, you need a proper password and maybe SSL as well.

I have made the necessary changes like
in the postgresql.conf file

listen_addresses = '*'
port = 5433

in the pg_hba.conf file
instead of 0.0.0.0 ipaddress of the server
host all all 0.0.0.0 255.255.255.0 md5


i have also provided a password.

but how to Make sure the firewall accepts incoming traffic


plz advice.

Thanks

What firewall are you using and does it have a manual?

I m using default windows firewall. and it is set to off...


anyways my problem is solved for communicating with postgresql from dotnet application.

there was a seamless_rotate = 1 i have set to 0 and re-install the service. it is returning me results.


Thanks all

Mohit