Re: psql: FATAL: the database system is starting up

Thanks everyone, it came back up a few minutes after I sent the SOS.

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
Sent: Thursday, September 21, 2006 11:58 AM
To: Mr. Dan
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] psql: FATAL: the database system is starting up

"Mr. Dan" <bitsandbytes88(at)hotmail(dot)com> 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