pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Mischa Sandberg <mischa_sandberg@telus.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: Reliably determining whether the server came up
Date: Tue, 18 Nov 2008 14:44:44 -0500
Message-ID: <23939.1227037484@sss.pgh.pa.us> (raw)
In-Reply-To: <1227035210.4923124a948e9@legacywebmail.telus.net>
References: <1226527535.491b532f4c45e@legacywebmail.telus.net>
	<491F1861.4060403@reedyriver.com>
	<1226780945.491f3111e22de@legacywebmail.telus.net>
	<1226781115.22056.1.camel@jd-laptop.pragmaticzealot.org>
	<49200BD8.4060703@reedyriver.com>
	<1226989027.49225de368848@legacywebmail.telus.net>
	<20048.1227023982@sss.pgh.pa.us>
	<1227026844.4922f19ce4c77@legacywebmail.telus.net>
	<22317.1227032425@sss.pgh.pa.us>
	<1227035210.4923124a948e9@legacywebmail.telus.net>

Mischa Sandberg <mischa_sandberg@telus.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



view thread (12+ messages)

Message-ID: <23939.1227037484@sss.pgh.pa.us>
Permalink:  ../23939.1227037484@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/23939.1227037484@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, mischa_sandberg@telus.net
  Subject: Re: Reliably determining whether the server came up
  In-Reply-To: <23939.1227037484@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox