pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Lane Van Ingen <lvaningen@esncc.com>
To: 'Tom Lane' <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Cc: stellr@cns.vt.edu
Subject: Re: What Are Last Steps Performed When PostgreSQL Starts?
Date: Wed, 27 Sep 2006 12:54:44 -0400
Message-ID: <TWMAIL6BtOdKMnap2SA00000097@twmail.ESNCC.COM> (raw)
In-Reply-To: <8673.1159366558@sss.pgh.pa.us>

Forgot about 'pg_ctl status'. That will work fine for my needs.

Ray Stell mentioned it would be helpful to see a description of all the 
things that go on from start to finish, in general or course. I agree. It
helps to know the logic going on behind the scenes when things break. I had
a problem in August where PostgreSQL would not come up; I finally traced it
to broken links in the libraries, but it took a long time to find .... and
there were no error messages logged to help. Does this kind of information
exist anywhere?

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us] 
Sent: Wednesday, September 27, 2006 10:16 AM
To: Lane Van Ingen
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] What Are Last Steps Performed When PostgreSQL Starts? 

"Lane Van Ingen" <lvaningen@esncc.com> writes:
> QUESTION: what are the few last steps that PostgreSQL does when it starts
> up? I am looking for things that I can check to be sure it has completed
> installation (from a script) before allowing the script to proceed to the
> next step, like:

I'm confused about whether you are talking about installation or server
startup.  If installation, shouldn't your script just be waiting for the
subprocess to exit?  As for server startup, the best procedure is the
one pg_ctl uses: try to make a connection, if fail, sleep a second or so
and try again.

			regards, tom lane




view thread (6+ messages)  latest in thread

Message-ID: <TWMAIL6BtOdKMnap2SA00000097@twmail.ESNCC.COM>
Permalink:  ../TWMAIL6BtOdKMnap2SA00000097@twmail.ESNCC.COM/
Also on:    postgresql.org/message-id/TWMAIL6BtOdKMnap2SA00000097@twmail.ESNCC.COM

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: lvaningen@esncc.com, tgl@sss.pgh.pa.us, stellr@cns.vt.edu
  Subject: Re: What Are Last Steps Performed When PostgreSQL Starts?
  In-Reply-To: <TWMAIL6BtOdKMnap2SA00000097@twmail.ESNCC.COM>
  References: <8673.1159366558@sss.pgh.pa.us> <TWMAIL6BtOdKMnap2SA00000097@twmail.ESNCC.COM>

* 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