Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group