How to determine failed connection attempt due to invalid authorization (libpq)?

Hi Dimitriy

Did you ever get an answer to your query regarding connection security.

I`m not only interested in this aspect, I am also interested in how to detect any unauthorized connection attempt whether through the front door or the back door.

Bob

From: Dmitriy Igrishin
Sent: Wednesday, October 13, 2010 11:58 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] How to determine failed connection attempt due to invalid authorization (libpq)?

Hey all,

We using libpq. There is only CONNECTION_BAD status which
is signaled about failed connection. Nevertheless, is there way
to check validity of username / password ?

--
// Dmitriy.