"David Parker" <dparker@xxxxxxxxxxxxxxxx> writes:
> 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.
Are we talking seconds, minutes, hours, days?
> 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.
If it's not doing recovery then the Postgres time proper should be
no more than a second or so, in my experience. Look for
outside-the-database factors. One possibility is a broken DNS
configuration leading to long delays in trying to resolve socket
addresses and such. I've never seen such a problem causing a delay
over a minute though ....
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
