Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group