Re: Corrupt database? 8.1/FreeBSD6.0 - Mailing list pgsql-general

From Jeff Amiel
Subject Re: Corrupt database? 8.1/FreeBSD6.0
Date
Msg-id 952344.50065.qm@web60819.mail.yahoo.com
Whole thread Raw
In response to Re: Corrupt database? 8.1/FreeBSD6.0  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Corrupt database? 8.1/FreeBSD6.0
List pgsql-general

Alvaro Herrera <alvherre@commandprompt.com> wrote:

Did you perchance connect to template0 (probably marking it as
connectable in the process), made some modification there, and then
mark it as non-connectable again, without executing VACUUM FREEZE on it?
AFAICS we only execute VACUUM FREEZE on it, so we shouldn't leave any
unfrozen tuples.

Nope.  Have never touched template0...haven't made any changes to pg_hba.conf (which is how I assume you would make template0 connectable) until last night when we determined that template0 might be at fault and we were going to run pg_filedump on it to see if we could find anything useful.

I assume this is similar/identical to this issue:
http://archives.postgresql.org/pgsql-hackers/2006-03/msg01294.php

Any ideas on how should I move forward?


Finding fabulous fares is fun.
Let Yahoo! FareChase search your favorite travel sites to find flight and hotel bargains.

pgsql-general by date:

Previous
From: Evgeny Gridasov
Date:
Subject: WAL question
Next
From: Alvaro Herrera
Date:
Subject: Re: WAL question