Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 0EE1E9FB298 for ; Wed, 27 Sep 2006 11:16:10 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 81329-01 for ; Wed, 27 Sep 2006 14:16:05 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id B7BA09FB308 for ; Wed, 27 Sep 2006 11:16:04 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k8REFwHw008674; Wed, 27 Sep 2006 10:15:58 -0400 (EDT) To: "Lane Van Ingen" cc: pgsql-admin@postgresql.org Subject: Re: What Are Last Steps Performed When PostgreSQL Starts? In-reply-to: References: Comments: In-reply-to "Lane Van Ingen" message dated "Wed, 27 Sep 2006 10:05:24 -0400" Date: Wed, 27 Sep 2006 10:15:58 -0400 Message-ID: <8673.1159366558@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200609/324 X-Sequence-Number: 23238 "Lane Van Ingen" 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