Question on start server using PG_CTL

From: "Mark Steben" <msteben(at)autorevenue(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Question on start server using PG_CTL
Date: 2009-08-03 15:31:10
Message-ID: 20090803153151.CB66C6340B2@mail.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi folks, were running Postgres 8.2.5 and Linux Redhat.

I run a cron script to start our server using pg_ctl after I copy the data
cluster over from a replicated server.
To test the start success / failure I test for the presence of
postmaster.pid in the cluster.
This weekend, the server started successfully but cron logic went down the
path that postmaster.pid didn't exist.

Do I need to perform another test,
Or
Is it possible that, during startup, postmaster.pid takes a second or two to
be created and hadn't been created yet when the test was run?
(Test run immediately after start command - perhaps I need to sleep for 5
seconds before the test).
Thanks for your time,

Mark Steben│Database Administrator
@utoRevenueR-"Join the Revenue-tion"
95 Ashley Ave., West Springfield, Ma
413-243-4800 x1512 (Phone) │ 413.732-1824 (Fax)
@utoRevenue is a registered trademark and a division of Dominion Enterprises

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2009-08-03 15:49:56 Re: Question on start server using PG_CTL
Previous Message Andrew Perrin 2009-08-03 14:30:21 Help! Upgrade to 8.4 dropped my databases