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

Re: We should Axe /contrib/start-scripts

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Josh Berkus <josh(at)agliodbs(dot)com>,Chander Ganesan <chander(at)otg-nc(dot)com>,PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: We should Axe /contrib/start-scripts
Date: 2009-08-25 19:48:07
Message-ID: 20090825194807.GK12604@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-hackers
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 ...

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

pgsql-hackers by date

Next:From: Chander GanesanDate: 2009-08-25 19:53:15
Subject: Re: We should Axe /contrib/start-scripts
Previous:From: Andrew DunstanDate: 2009-08-25 19:46:31
Subject: Re: We should Axe /contrib/start-scripts

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