Re: Reindex from command line linux

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)

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?



Fabio Barón S.
DBA, Plataforma Tecnologica
Gerencia Corporativa de Tecnologia
Tel : 4-37-61-61  Ext.  5123
Cel : 311 2-54-74-00



             Bruno Wolff III
             <bruno@wolff.to>
                                                                      Para
             22/04/2005 11:39          FBaron@co.belcorp.biz
             a.m.                                                       cc
                                       pgsql-admin@postgresql.org
                                                                    Asunto
                                       Re: Reindex from command line linux










On Fri, Apr 22, 2005 at 11:04:03 -0500,
  FBaron@co.belcorp.biz wrote:
>
>
>
>
> hi, which is the sentence to run a Database REINDEX from linux or from
> script or shell,etc.

I think you can use:
psql -c 'REINDEX DATABASE database_name'