database corruption help
| От | John Lister |
|---|---|
| Тема | database corruption help |
| Дата | |
| Msg-id | 507152DDF8AB4DF093BD01A8BEC7C659@squarepi.com обсуждение исходный текст |
| Ответы |
Re: database corruption help
|
| Список | pgsql-admin |
Hi, my wal archiving broke and postgresql filled up the local disk with transaction logs, which i foolishly deleted in a moment of madness, after resetting the transaction log a few of my tables are damaged but repairable. However the system tables also seemed to have suffered. My main problem is duplicate rows which violated the primary key and if i do a reindex system i get similar errors, for example:
ERROR: could not create unique index "pg_class_oid_index"
a quick inspection of the pg_class table doesn't show any duplicates, is there anyway i can find out which row(s) are duplicated and remove them without a full db restore?
also doing something like this doesn't return anything which worked for my other tables
select oid from pg_class where oid in(select oid from pg_class group by oid having count(oid)>1 )
Many thanks
--
Got needs? Get Goblin'! - http://www.pricegoblin.co.uk/
В списке pgsql-admin по дате отправления: