Re: [GENERAL] Database corruption with duplicate tables.

2010-04-19 Thread George Woodring
The version is 8.3.3, and I use autovacuum for the routine maintenance. The ctid's are distinct grande=# select oid, ctid, relname from pg_class where oid IN (26770910, 26770918, 26770919, 26770920); oid| ctid |relname --+-+--

Re: [GENERAL] Database corruption with duplicate tables.

2010-04-19 Thread Tom Lane
George Woodring writes: > Upon investigation I found that I have a table that is in the database twice > db=> select oid, relname from pg_class where oid IN (26770910, > 26770918, 26770919); >oid|relname > --+--- > 26770910 | av

Re: [GENERAL] Database corruption with duplicate tables.

2010-04-19 Thread Alvaro Herrera
George Woodring wrote: > I have found that I have a database problem after receiving the > following error from pg_dump: Lack of vacuuming, most likely. What version is this? Did you read previous threads about this problem on the archives? -- Alvaro Herrerahttp