pg_class relfilenode
От | Muteki Fong |
---|---|
Тема | pg_class relfilenode |
Дата | |
Msg-id | 20040210092325.76215.qmail@web41003.mail.yahoo.com обсуждение исходный текст |
Список | 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
В списке pgsql-general по дате отправления: