Thanks everyone, it came back up a few minutes after I sent the SOS.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Thursday, September 21, 2006 11:58 AM
To: Mr. Dan
Cc: [email protected]
Subject: Re: [ADMIN] psql: FATAL: the database system is starting up
"Mr. Dan" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
