[GENERAL] URGENT: Index problems
I added a hash index to a varchar value and when i vacuumed i got the following error: Index customer_ha_hash: NUMBER OF INDEX' TUPLES (9176) IS NOT THE SAME AS HEAP' (9181). dropping and recreating the index gave me the same error (on this index only) dropping the database and reimporting the data and then recreating the index and vacuuming gave me the same error. any ideas ? ... and does anyone know what the error means ? thanks in advance. Steve ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] URGENT: Index problems - update - please help ....
okay. i followed the instructions very carefully and get the following error when i try to run pg_upgrade .. Cannot find database template1 in ./data/base. Are you running ./pg_upgrade as the postgres superuser? i am running as superuser and template1 is not there. Steve Steve Brett [EMAIL PROTECTED] wrote in message 9qjgpp$3h3$[EMAIL PROTECTED]">news:9qjgpp$3h3$[EMAIL PROTECTED]... I added a hash index to a varchar value and when i vacuumed i got the following error: Index customer_ha_hash: NUMBER OF INDEX' TUPLES (9176) IS NOT THE SAME AS HEAP' (9181). dropping and recreating the index gave me the same error (on this index only) dropping the database and reimporting the data and then recreating the index and vacuuming gave me the same error. any ideas ? ... and does anyone know what the error means ? thanks in advance. Steve ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] URGENT: Index problems
apparently this is the fix: psql -d mydb -c select * from title; before # Save for after cmp test... cd /usr/local/pgsql # my install root... vacuumdb mydb# clean up before moving... cp -pr data data.backup # make a backup... pg_dumpall -s schema.sql # dump schema w/out data... killall postmaster # stop the server... sleep 3 mv data data.old # set it aside... cd /usr/src/pgsql/src# to the src tree... gmake install# reinstall binaries... cd /usr/local/pgsql # back to my install root... initdb # recreate template1, sys stuff... postmaster -i -o -F -S 4096 -s log # restart server... sleep 3 pg_upgrade -f schema.sql data upgrade.log # reload schema... cp -p data.old/base/mydb/* data/base/mydb/ # replace data... psql -d mydb -c select * from title; after # verify we still have data... diff before after# quick sanity check... will let you know if it works ... Steve Brett [EMAIL PROTECTED] wrote in message 9qjgpp$3h3$[EMAIL PROTECTED]">news:9qjgpp$3h3$[EMAIL PROTECTED]... I added a hash index to a varchar value and when i vacuumed i got the following error: Index customer_ha_hash: NUMBER OF INDEX' TUPLES (9176) IS NOT THE SAME AS HEAP' (9181). dropping and recreating the index gave me the same error (on this index only) dropping the database and reimporting the data and then recreating the index and vacuuming gave me the same error. any ideas ? ... and does anyone know what the error means ? thanks in advance. Steve ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])