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

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

From: "Shoaib Mir" <shoaibmir(at)gmail(dot)com>
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:51:55
Message-ID: bf54be870609210851s5b097bc7xa02cdba3bf421bf0@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Try using the fast shutdown switch with pg_ctl i.e. -mf, that might help.

Thanks,
-- 
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 9/21/06, Mr. Dan <bitsandbytes88(at)hotmail(dot)com> wrote:
>
> Hi,
>
> 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.   Developers
> are
> coming into my office every 5 minutes asking for updates.   It's never
> taken
> this long to come back.  We did have an awful lot of transactions last
> night.    Is the server replaying everything
>
> fhttp://by116fd.bay116.hotmail.msn.com/cgi-bin/compose?&curmbox=00000000%2d0000%2d0000%2d0000%2d000000000001&a=3b0ef010ec78a7ca825dcdc7953aaf4c22ff15917d66f2ef8a3ddf1fd5dbd659#
> Sendrom the last succesful backup?   Is it hanging because it can't find
> some WAL files that were archived?  It's been an hour and a half so far.
> Would a reboot help?
>
> ~DjK
>
>
>
>
>
> ep 21 10:07:05 p postgres[28301]: [2-3]  recovery.
> Sep 21 10:07:05 p postgres[28301]: [3-1] < % %2006-09-21 10:07:05 EDT>LOG:
> checkpoint record is at 14D/69FFBD8
> Sep 21 10:07:05 p postgres[28301]: [4-1] < % %2006-09-21 10:07:05 EDT>LOG:
> redo record is at 14D/696AC20; undo record is at 0/0; shutdown FALSE
> Sep 21 10:07:05 p postgres[28301]: [5-1] < % %2006-09-21 10:07:05 EDT>LOG:
> next transaction ID: 39405490; next OID: 1799955
> Sep 21 10:07:05 p postgres[28301]: [6-1] < % %2006-09-21 10:07:05 EDT>LOG:
> next MultiXactId: 5696; next MultiXactOffset: 11694
> Sep 21 10:07:05 p postgres[28301]: [7-1] < % %2006-09-21 10:07:05 EDT>LOG:
> database system was not properly shut down; automatic recovery in progress
> Sep 21 10:07:05 p postgres[28301]: [8-1] < % %2006-09-21 10:07:05 EDT>LOG:
> redo starts at 14D/696AC20
> Sep 21 10:07:20 p postgres[28305]: [2-1] <[unknown] %[unknown] %2006-09-21
> 10:07:20 EDT>LOG:  invalid length of startup packet
>
>
>
> ---------------------------(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
>

In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2006-09-21 15:58:15
Subject: Re: psql: FATAL: the database system is starting up
Previous:From: Mr. DanDate: 2006-09-21 15:45:06
Subject: psql: FATAL: the database system is starting up

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