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]

Reply via email to