-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 12/30/2014 08:43 AM, Greg Sabino Mullane wrote:
> I am working on enhancing the ping() method of DBD::Pg. The goal of
> that is for a user to be able to determine if the connection to the
> database is still valid.
This entire concept is flawed. IM
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Andrew Gierth asked:
>> this is to send a simple SELECT via PQexec
>
> Why not PQexec(conn, "") ?
Because I want to leave a good clue for debugging; so
DBAs are better able to figure out where a mystery slew of
queries is coming from. The que
On 12/29/14, 6:43 PM, Greg Sabino Mullane wrote:
I am working on enhancing the ping() method of DBD::Pg. The goal of that
is for a user to be able to determine if the connection to the database
is still valid.
This is actually a VERY common thing for monitoring frameworks to do.
Currently, the
> "Greg" == Greg Sabino Mullane writes:
Greg> I am working on enhancing the ping() method of DBD::Pg. The
Greg> goal of that is for a user to be able to determine if the
Greg> connection to the database is still valid. The basic way we do
Greg> this is to send a simple SELECT via PQexec
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
I am working on enhancing the ping() method of DBD::Pg. The goal of that
is for a user to be able to determine if the connection to the database
is still valid. The basic way we do this is to send a simple SELECT via
PQexec and then check for