7.3.4 Table corruption
От | Andrew Farmer |
---|---|
Тема | 7.3.4 Table corruption |
Дата | |
Msg-id | 412BEE3D.8070409@andrewfarmer.com обсуждение исходный текст |
Ответы |
Re: 7.3.4 Table corruption
|
Список | pgsql-admin |
I'm running a 7.3.4 on a RedHat 7.2 i686 box. I take daily backups of my application's database, and last week it failed on one of the tables. After some checking I found that the rest of the data was ok, just a large number of tuples on one table were corrupt. I'm pretty sure it's table corruption, as a REINDEX does not solve the problem, and I can't COPY data from the table. I have backups I can use, but I only want to restore this one table, which would not normally be a big problem, as I can just pull the relevant commands out of the dump file. But there are a lot of connections through rules and references from the broken table to other tables, so I can't simply truncate this table and reload it, I would have to reload a large number of other tables as well. Something I don't really want to do, as I could potentially lose more data. My question is, if I load the good dump into a clean database, and then find the underlying file that represents the broken table and copy it over the top of the broken table, am I likely to face any big problems? Thanks Andrew
В списке pgsql-admin по дате отправления: