Re: [GENERAL] Postgres and Upstart

2012-08-10 Thread Albe Laurenz
Chris Angelico wrote: > I'm looking for a reliable way to be sure that Postgres has finished > its initialization and is ready to rumble. The normal way to test this is a connection attempt. You could also look into the server logs for the appropriate message, but that seems more fragile and diffi

[GENERAL] Postgres and Upstart

2012-08-10 Thread Chris Angelico
We run a multi-node replication setup with an in-house monitoring program that decides when to promote a slave, etc, etc. Everything is managed through Upstart. I'm looking for a reliable way to be sure that Postgres has finished its initialization and is ready to rumble. Especially, I don't want