Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 8A2039FB303 for ; Wed, 27 Sep 2006 13:28:21 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 26206-02 for ; Wed, 27 Sep 2006 13:28:11 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from twmail.ESNCC.COM (static-66-173-159-28.t1.cavtel.net [66.173.159.28]) by postgresql.org (Postfix) with SMTP id 71FE39FB2DF for ; Wed, 27 Sep 2006 13:28:11 -0300 (ADT) Received: from spawar2i8uvlb9 ([150.125.117.63]) by twmail.ESNCC.COM with Microsoft SMTPSVC(6.0.3790.1830); Wed, 27 Sep 2006 12:28:10 -0400 From: "Lane Van Ingen" To: "'Tom Lane'" Cc: , Subject: Re: What Are Last Steps Performed When PostgreSQL Starts? Date: Wed, 27 Sep 2006 12:54:44 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2757 In-Reply-To: <8673.1159366558@sss.pgh.pa.us> Thread-Index: AcbiP3YrSiiVhniuQBSQe/8XSAQUQwAFFhPQ Message-ID: X-OriginalArrivalTime: 27 Sep 2006 16:28:10.0494 (UTC) FILETIME=[EBEB69E0:01C6E251] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.178 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200609/329 X-Sequence-Number: 23243 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" 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