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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 md5
  3. postgres.conf has:

    listen_addresses = *

  4. client is Windows XP 32bit, server is 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.


migration rejected from Jun 15 '13 at 15:57

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as too localized by dezso, StanleyJohns, Jon Seigel, Mark Storey-Smith, Craig Ringer Jun 15 '13 at 15:57

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the 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 '13 at 19:31
nice. connecting with the postgres user. – swasheck May 14 '13 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 '13 at 21:06