Inaccessible table??
От | Thomas Reinke |
---|---|
Тема | Inaccessible table?? |
Дата | |
Msg-id | 36B327B3.35E96ABE@e-softinc.com обсуждение исходный текст |
Список | pgsql-general |
Hi folks...need some help with data recovery. I've been using postgres somewhat successfully (success - reliability problems) for about a year. Today I have run into a major problem: I have a 1.6 million record table, and I cannot get access to all of the data in the table. Specifically: 1. The table is visible to clients - i.e. you can attempt a select, pg_dump, etc. 2. If a pg_dump is attempted on the table, only the first 761 rows are dumped. Thereafter, the server task spins forever chewing up CPU cycles and never dumps an additional record. In once case (prior to me killing the task) I witnessed it consuming 4 hours of CPU time. 3. vacuum does the same...If I vacuum the db, it vacuums almost everything but this table (i.e. it gets stuck on what I think is this table). If a vacuum the table directly, the server task spins endlessly. 4. Select statements hang forever (same effect) All other tables behave "normally". I have some rather important data collected in this table over the past 8 days (since the last backup), and would like to try to recover it if at all possible. Any ideas? Thomas
В списке pgsql-general по дате отправления: