From: | Muteki Fong <szemingfong(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_class relfilenode |
Date: | 2004-02-10 09:23:25 |
Message-ID: | 20040210092325.76215.qmail@web41003.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I am currently having the corrupted tables issues
described in the following link (possibly caused by
power failure,
http://archives.postgresql.org/pgsql-admin/2003-04/msg00012.php)
Since we have our systems being deployed to different
clients (psql 7.2.3), upgrading the entire database
(with data migration) will be the least preferable
solution. I am thinking of creating a script that
periodically check the relfilenode inside the pg_class
and if there is any mismatch between what pg_class
described and what actually exists in the file system,
the script will touch that file and try to drop the
table. However, once I wrote the script and started
testing it, I found that there are already some files
(mainly pg_*) tables/indexes are not being consistent
with the filesystem. Is it going to harm the database
if I blindly touch those files? Or is there any
workaround/trick/patch I can apply to version 7.2.3
without upgrading the whole database?
Thanks,
--szeming
__________________________________
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Michel POURE | 2004-02-10 09:36:37 | Re: I want to use postresql for this app, but... |
Previous Message | Mark Gibson | 2004-02-10 09:08:33 | Re: newbie pl/pgsql question on trigger function error |