Re: Reliably determining whether the server came up

From: Mischa Sandberg <mischa_sandberg(at)telus(dot)net>
To: "H(dot) Hall" <hhall1001(at)reedyriver(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Reliably determining whether the server came up
Date: 2008-11-18 06:17:07
Message-ID: 1226989027.49225de368848@legacywebmail.telus.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sabin Coanda 2008-11-18 10:40:13 raise doesn't add end of line
Previous Message Mischa Sandberg 2008-11-18 05:38:44 Re: Reliably determining whether the server came up