Simple DB presence verifier.
От | Damian C |
---|---|
Тема | Simple DB presence verifier. |
Дата | |
Msg-id | 2bbc8f530703041340t24caf87p4c04fd55b91a11a5@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Simple DB presence verifier.
Re: Simple DB presence verifier. |
Список | pgsql-novice |
Hello, This is a real novice question! We are developing a distributed (~1-10 PCs) Java office application that uses Postgres as the central data store. We are capable Java developers, but our Postgres skills are limited because it is primarily hidden behind Hibernate ORM. Our product is aimed at a "technically illiterate small business" market, so there will be no fancy equipment or system administrators, and "forgetting to turn on the server" will be a common fail case. Our use case involves the java desktops checking to see if Postgres is available at (1) startup, and (2) ongoing "watchdog", perhaps every minute or so. My first attempt has been to write a query such as "SELECT last_value FROM est_sequence". If the query fails then we can conclude that the database is not present. What we are looking for is a simple, low overhead, "quick succeed, catchable fail", way to check if the database is available. Can anyone suggest an improved technique to check for database presence?? All suggestions welcome. Many thanks, -Damian
В списке pgsql-novice по дате отправления: