From: | "Mr(dot) Dan" <bitsandbytes88(at)hotmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | psql: FATAL: the database system is starting up |
Date: | 2006-09-21 15:45:06 |
Message-ID: | BAY116-F2291976B73DD20AD58C7F8D1200@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Shoaib Mir | 2006-09-21 15:51:55 | Re: psql: FATAL: the database system is starting up |
Previous Message | Jose Manuel Garcia Valladolid | 2006-09-21 10:40:55 | WAL configuration and REINDEX |