Re: Reliably determining whether the server came up

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mischa Sandberg <mischa_sandberg(at)telus(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Reliably determining whether the server came up
Date: 2008-11-18 19:44:44
Message-ID: 23939.1227037484@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Mischa Sandberg <mischa_sandberg(at)telus(dot)net> writes:
>> You could sleep for a second or so *before* you start looking for
>> the pidfile.

> The systems are under erratic load, due to concurrent
> cpu and diskio spikes around start-up time.
> 1-2 secs is not enough to be a guarantee :-(

Well, forget pg_ctl and just start the postmaster directly, so that
your script knows its PID. Then you could keep an eye on whether the
PID still exists.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Arctic Toucan 2008-11-18 21:33:52 Re: Is it safe to reset relfrozenxid without using vacuum?
Previous Message Mischa Sandberg 2008-11-18 19:06:50 Re: Reliably determining whether the server came up