Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

The error: "Unable to read data from the transport connection. an existing connection was forcibly
closed by the remote host."

The conditions:

1) I have the following connection string:
    server = "CIRMS01"
    password = "password"
    user id = "postgres"
    database = "egov_euc"
    port = "5432"

2) pg_hba.conf  has:
    host all all 150.46.1.9/32 md5

3) postgres.conf has:
   listen_addresses = *

4) client = Windows XP 32bit
   server = Windows 2008 Server 64bit

I don't know what seems to be the problem why it is prompting the error message above and why it cannot connect. I googled it but there seems I cannot find a clear cut
solution.

share|improve this question
Do you see this after every attempt to connect? Can you connect the server from the client machine with psql, for example? – dezso Apr 13 at 19:31
nice. connecting with the postgres user. – swasheck May 14 at 21:05
also, do you have the windows firewall off? if it's on, is it configured to allow connections to the db server? – swasheck May 14 at 21:06

migrated from stackoverflow.com Mar 14 at 13:44

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.