Re: Database corupption on pg 7.3.3

7.3.4 fixes a problem with recovery failure after crash.  You should
definitely upgrade.

On Sat, Aug 30, 2003 at 10:44:07AM +0200, pginfo wrote:

> After working some days pg crashes and I was not able to restore it.
>
> I found tis messages into the log:
> Lock file "/mnt/diske/skladdb/postmaster.pid" already exists.
> Is another postmaster (pid 1208) running in "/mnt/diske/skladdb"?
> LOG:  database system was interrupted at 2003-08-22 20:10:51 EEST
> LOG:  checkpoint record is at 0/1829A1E4
> LOG:  redo record is at 0/1829A1E4; undo record is at 0/0; shutdown
> FALSE
> LOG:  next transaction id: 45726; next oid: 13875914
> LOG:  database system was not properly shut down; automatic recovery in
> progress
> LOG:  redo starts at 0/1829A224
> PANIC:  Invalid page header in block 4 of 16645

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Puedes vivir solo una vez, pero si lo haces bien, una vez es suficiente"