|
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/
|
