Chander Ganesan wrote:
> Alvaro Herrera wrote:
> >This is something we're not quite ready on, yet. We need some mechanism
> >that allows scripts to verify not only that postmaster started, but also
> >that it has finished recovery. You can sort-of do it by attempting a
> >connection and checking the error message, but it's ugly. There was
> >talk about a pg_ping utility years ago, but nobody got around to writing
> >it ...
> Can't you use pg_controldata to see whether it is in recovery or
> not? Seems like you've got a way to see if it's running, seeing if
> it is in recovery should therefore be pretty straightforward, no?
That's within my definition of "ugly", yes :-) My ideal tool would do
something like
$ pg_ping -h foo -p 5555
IN_RECOVERY
$ echo $?
2
$ # sleep a bit ...
$ pg_ping -h foo -p 5555
READY
$ echo $?
0
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
