Re: [GENERAL] startup time

2005-06-24 Thread Tom Lane
"David Parker" <[EMAIL PROTECTED]> writes: > Does pg_ctl status return true even if the database is not ready yet to > receive requests? pg_ctl status just checks that the postmaster process is present. (Until very recently, it wasn't even a bulletproof test for that...) r

Re: [GENERAL] startup time

2005-06-24 Thread David Parker
Does pg_ctl status return true even if the database is not ready yet to receive requests? We are using pg_ctl status to tell us if the database is up, but I'm wondering if it could return true, but a client could connect and still get the "FATAL: database is starting up" error? - DAP >"David Par

Re: [GENERAL] startup time

2005-06-21 Thread David Parker
>> 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? It's in the seconds range, I think, probably not more than a minute, but I don

Re: [GENERAL] startup time

2005-06-21 Thread Tom Lane
"David Parker" <[EMAIL PROTECTED]> 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 o

[GENERAL] startup time

2005-06-21 Thread David Parker
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 i