From:
Chander Ganesan <chander(at)otg-nc(dot)com>
To:
Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc:
Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>,
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,
Josh Berkus <josh(at)agliodbs(dot)com>,
PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: We should Axe /contrib/start-scripts
Date:
2009-08-25 19:53:15
Message-ID:
4A94412B.2000905@otg-nc.com (view raw or flat )
Thread:
2009-08-19 18:18:20 from Josh Berkus <josh(at)agliodbs(dot)com>
2009-08-19 18:39:39 from Chander Ganesan <chander(at)otg-nc(dot)com>
2009-08-19 18:48:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-08-19 18:55:22 from Josh Berkus <josh(at)agliodbs(dot)com>
2009-08-19 19:01:30 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-08-19 20:09:08 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-08-19 21:03:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-08-19 21:14:28 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2009-08-19 21:29:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-08-19 21:22:23 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-08-19 21:32:35 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-08-19 22:13:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-08-19 22:46:15 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-08-19 22:52:25 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-08-25 19:34:28 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-08-25 19:46:31 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2009-08-25 19:54:06 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-08-25 20:13:24 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-08-25 21:23:17 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2009-08-25 19:48:07 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-08-25 19:53:15 from Chander Ganesan <chander(at)otg-nc(dot)com>
2009-08-25 20:03:44 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-08-25 20:11:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-08-25 20:27:22 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-08-25 20:41:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-08-25 21:26:11 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-08-25 22:03:30 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-08-25 22:31:50 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-08-25 22:42:12 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-08-25 23:07:04 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-08-26 14:53:58 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-08-26 15:05:38 from Chander Ganesan <chander(at)otg-nc(dot)com>
2009-08-26 15:09:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-08-26 15:23:06 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-08-26 00:17:01 from Aidan Van Dyk <aidan(at)highrise(dot)ca>
2009-08-26 00:22:16 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-08-26 00:44:17 from Chander Ganesan <chander(at)otg-nc(dot)com>
2009-08-26 23:32:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-08-26 23:51:30 from Greg Stark <gsstark(at)mit(dot)edu>
2009-08-27 00:01:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-08-27 00:27:42 from Greg Stark <gsstark(at)mit(dot)edu>
2009-08-27 00:38:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-08-27 00:59:02 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2009-08-27 01:02:40 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-08-27 06:54:22 from Magnus Hagander <magnus(at)hagander(dot)net>
2009-08-25 20:16:34 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-08-25 20:41:41 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-08-25 20:46:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-08-25 20:47:28 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-08-19 21:52:32 from Greg Stark <gsstark(at)mit(dot)edu>
2009-08-19 22:18:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-08-19 20:31:47 from Josh Berkus <josh(at)agliodbs(dot)com>
2009-08-19 21:02:54 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-08-19 18:58:56 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2009-08-19 19:01:16 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-08-19 19:06:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-08-19 19:00:00 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Lists:
pgsql-hackers
Alvaro Herrera wrote:
> Kevin Grittner wrote:
>
>
>> The reason is that we don't want certain other processes attempting to
>> start until and unless the database they use has started successfully.
>>
>
> 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?
--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
919-463-0999/877-258-8987
http://www.otg-nc.com
In response to
Responses
pgsql-hackers by date
Next :From: Tom LaneDate: 2009-08-25 19:54:06Subject : Re: We should Axe /contrib/start-scripts Previous :From : Alvaro HerreraDate : 2009-08-25 19:48:07Subject : Re: We should Axe /contrib/start-scripts
