Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group