On Fri, Apr 22, 2005 at 11:36:46 -0500,
FBaron@co.belcorp.biz wrote:
>
>
>
>
> thanks Bruno :
> I'm running the command with root
> psql -c "REINDEX DATABASE Clibelcorpco FORCE"
> psql: FATAL: La base de datos "root" no existe en el catalogo del
> sistema.(Traslate : The "root" database doesn´t exsists)
You need to run it as the Postgres superuser instead of "root".
> I execute :
>
> psql -d Clibelcorpco -c "REINDEX DATABASE Clibelcorpco FORCE"
> ERROR: REINDEX DATABASE: Can be executed only on the currently open
> database.
>
> what do you think?
I am not sure what is happening in this case. It might be a case mismatch
on the database name.