"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
pgsql-admin by date
|Next:||From: Rodrigo Sakai||Date: 2006-09-21 17:07:40|
|Subject: Estimating a table size|
|Previous:||From: Shoaib Mir||Date: 2006-09-21 15:51:55|
|Subject: Re: psql: FATAL: the database system is starting up|