I'm writing a pool manager to manage x connections to a pgsql postmaster.

The getConnection method has to check if the connection is still valid,
and try to reconnect if it ain't.

Do you guys have a good way of doing this?

Can I use PQstatus?

Should I make a little runCommand on it to try it out? Then what command?

If it's bad, should I run a PQfinish on it before reconnecting or not?

Thank you plenty!

---
Daniel Akerud

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Reply via email to