Re: Reindex from command line linux

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.