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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mr(dot) Dan" <bitsandbytes88(at)hotmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: psql: FATAL: the database system is starting up
Date: 2006-09-21 15:58:15
Message-ID: 1347.1158854295@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rodrigo Sakai 2006-09-21 17:07:40 Estimating a table size
Previous Message Shoaib Mir 2006-09-21 15:51:55 Re: psql: FATAL: the database system is starting up