Thanks everyone, it came back up a few minutes after I sent the SOS. -----Original Message----- From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Tom Lane Sent: Thursday, September 21, 2006 11:58 AM To: Mr. Dan Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: [ADMIN] psql: FATAL: the database system is starting up "Mr. Dan" <bitsandbytes88@xxxxxxxxxxx> writes: > We had to kill postmaster, and it's been ugly. The last backup finished > successfully not last night, but the night before. This is 161 GB database. > How long should I expect this to take before it starts. Not longer than the time since the last checkpoint. What does pg_controldata show? Is the recovery process actually doing any work? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
