Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 5F10A64FD03 for ; Tue, 18 Nov 2008 02:17:23 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 67087-07 for ; Tue, 18 Nov 2008 02:17:20 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from defout.telus.net (defout.telus.net [204.209.205.13]) by mail.postgresql.org (Postfix) with ESMTP id AAFBB64FD13 for ; Tue, 18 Nov 2008 02:17:19 -0400 (AST) Received: from localhost ([204.209.205.55]) by priv-edmwes51.telusplanet.net (InterMail vM.7.08.03.00 201-2186-126-20070710) with ESMTP id <20081118061707.PMVD10956.priv-edmwes51.telusplanet.net@localhost>; Mon, 17 Nov 2008 23:17:07 -0700 Received: from 75.157.220.38 ( [75.157.220.38]) as user a3a18850@204.209.205.54 by legacywebmail.telus.net with HTTP; Mon, 17 Nov 2008 22:17:07 -0800 Message-ID: <1226989027.49225de368848@legacywebmail.telus.net> Date: Mon, 17 Nov 2008 22:17:07 -0800 From: Mischa Sandberg To: "H. Hall" Cc: pgsql-admin@postgresql.org Subject: Re: Reliably determining whether the server came up References: <1226527535.491b532f4c45e@legacywebmail.telus.net> <491F1861.4060403@reedyriver.com> <1226780945.491f3111e22de@legacywebmail.telus.net> <1226781115.22056.1.camel@jd-laptop.pragmaticzealot.org> <49200BD8.4060703@reedyriver.com> In-Reply-To: <49200BD8.4060703@reedyriver.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.1-cvs X-Originating-IP: 75.157.220.38 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200811/93 X-Sequence-Number: 30747 Perhaps it's my "test for DB ready" that's the problem? This is the typical glitch I get ... + mkdir -p /persist/pgdata + chmod 700 /persist/pgdata + initdb -Atrust -Upmx -L/persist/pgsql/8.0.9/share >/dev/null + cp -p /persist/etc/p*g*.conf /persist/pgdata + chmod u+w /persist/home/mischa/pgdata/*.conf + pgconf dynamic_library_path=/persist/pgsql/8.0.9/lib + touch pg-Mon.log >/tmp/pg.5432.log + mkdir -p /persist/pglog + cd /persist/pglog + pg_ctl start -s -l /tmp/pg.5432.log -o '-p 5432 -B 500 -N 10' + while pg_ctl status && ! psql -l; do sleep 1; done >/dev/null 2>&1 + createlang --pglib /persist/pgsql/8.0.9/lib -d template1 plpgsql createlang: could not connect to database template1: FATAL: the database system is starting up -- Engineers think that equations approximate reality. Physicists think that reality approximates the equations. Mathematicians never make the connection.