"Dot Yet" <dot(dot)yet(at)gmail(dot)com> writes:
> I am seeing this "Connection reset by peer" message in the
> postmaster.logfile, but the connection between the client and server
> does get established
> and works fine too...
What pg_hba.conf setup are you using? I'm thinking that this might be
expected behavior if it's password-based, because psql drops the
connection before prompting the user for a password when the server
tells it a password is needed.
regards, tom lane