Re: What Are Last Steps Performed When PostgreSQL Starts? - Mailing list pgsql-admin

From Tom Lane
Subject Re: What Are Last Steps Performed When PostgreSQL Starts?
Date
Msg-id 8673.1159366558@sss.pgh.pa.us
Whole thread Raw
In response to What Are Last Steps Performed When PostgreSQL Starts?  ("Lane Van Ingen" <lvaningen@esncc.com>)
Responses Re: What Are Last Steps Performed When PostgreSQL Starts?  ("Lane Van Ingen" <lvaningen@esncc.com>)
List pgsql-admin
"Lane Van Ingen" <lvaningen@esncc.com> 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

pgsql-admin by date:

Previous
From: Ray Stell
Date:
Subject: Re: What Are Last Steps Performed When PostgreSQL Starts?
Next
From: Edoardo Ceccarelli
Date:
Subject: autovacuum on a -mostly- r/o table