Re: Database corupption on pg 7.3.3 - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Database corupption on pg 7.3.3
Date
Msg-id 20030830201048.GB12214@dcc.uchile.cl
Whole thread Raw
In response to Database corupption on pg 7.3.3  (pginfo <pginfo@t1.unisoftbg.com>)
List pgsql-general
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"

pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: After install 7.3.4, I got a 7.3.3 ver. no?
Next
From:
Date:
Subject: cursor bug