We have a script
process that needs to start a database, execute some SQL statements, then stop
the database. This is done as part of an application reset, in which we are
clearing out database data as part of the process. This is with 7.4.5 on Solaris
9/intel.
The problem we are
having is that in a customer installation, the startup on the database is taking
significantly longer than we have ever seen it take before. The script needs to
be fixed because it has a hard-coded wait interval value (looping over a "pg_ctl
status"), and it's not stopping properly, so we end up trying to make a
connection before the database is up, getting the "FATAL: database is starting
up" error.
But what I'm curious
about is what set of things have to happen between startup and the server being
ready to accept requests. This happens on a fresh install, so I don't *think* it
should be recovery processing. It's difficult to diagnose because I don't have
access to the installation.
If somebody could
point me to the area of code that handles startup, a link to documentation,
and/or a bullet list of things that get done in this startup window, it
would give me a starting point for asking questions of our field people about
the installation environment.
Thanks.
-
DAP
----------------------------------------------------------------------------------
David
Parker Tazz Networks (401)
709-5130
