LOG: could not receive data from client: No connection could be made
because the target machine actively refused it.

I get this message during a session - not at the beginning. I'm a Postgres
newbie, and don't understand why the connection would become "refused".

Thanks,
Rocky

Rocky Phelps <rockyp (AT) rockyp (DOT) com> wrote:
As far as I can tell from the source, this message ('no connection could
be made...') comes from the operating system. Are you on Windows?
What version of PostgreSQL are you running?

When you say 'during the session', do you mean that you have already sent
requests and received responses in this session?

What is the client program you are using?

Is there a firewall between client and server?
Are there any antivirus programs reporting activity?
If any of the above, does the problem also occur when firewall and
antivirus software are disabled?

Are you aware of anything that triggers that behaviour, like certain
requests or longer inactivity? Or is it totally randon?

Yours,
Laurenz Albe

Rocky Phelps <rockyp (AT) rockyp (DOT) com> writes:

The server is saying that the client refused a connection? By
definition the client is the one that initiates a connection. My first
guess would be that the server is trying to connect to identd on the
client's host. What authentication are you configured to expect?

I would think authentication would happen at or very near the beginning.
If this isn't a connection to identd then I have no idea. You might try
one of the postgresql mailing lists. I hear they're more active than
the newsgroup.

You are right that a connection cannot become refused once it's
established; it can only be closed. The message must refer to a
separate connection attempt.