Re: [GENERAL] vacuumdb is failing with NUMBER OF INDEX TUPLES NOT

2004-05-08 Thread Tom Lane
Denis Braekhus <[EMAIL PROTECTED]> writes: > Indicating that they should produce the same results, but that they work > differently. I am not sure what that implies, but maybe someone else knows ? The only difference the docs are talking about is what kind of lock is held while the rebuild proceed

Re: [GENERAL] vacuumdb is failing with NUMBER OF INDEX TUPLES NOT

2004-05-08 Thread Denis Braekhus
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Lonni Friedman wrote: | Thanks for your reply. I thought (perhaps erroneously) that there | wasn't any real difference between dropping an index then recreating | it, and just reindexing an index? I am definitely not sure, and I agree it sounds logica

[GENERAL] duplicate key violates unique constraint "pg_class_oid_index"

2004-05-08 Thread David Garamond
postgresql 7.4.0, redhat 7.3 (under vmware 4.0 on win2k) Windows crashed and some of the files on Redhat got corrupted, including some files in /var/lib/pgsql/data/pg_xlog/. When I tried to start postmaster, it fails with message "Invalid primary checkPoint record". I think it was trying to look f