| From: | Jeff Amiel <becauseimjeff(at)yahoo(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Corrupt database? 8.1/FreeBSD6.0 |
| Date: | 2007-01-12 13:48:35 |
| Message-ID: | 952344.50065.qm@web60819.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Alvaro Herrera <alvherre(at)commandprompt(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2007-01-12 13:49:04 | Re: WAL question |
| Previous Message | Evgeny Gridasov | 2007-01-12 13:23:06 | WAL question |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2007-01-12 13:48:59 | Re: to_char not IMMUTABLE? |
| Previous Message | Alvaro Herrera | 2007-01-12 12:47:27 | Re: Corrupt database? 8.1/FreeBSD6.0 |