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]