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(at)wolff(dot)to>
Para
22/04/2005 11:39 FBaron(at)co(dot)belcorp(dot)biz
a.m. cc
pgsql-admin(at)postgresql(dot)org
Asunto
Re: Reindex from command line linux

On Fri, Apr 22, 2005 at 11:04:03 -0500,
FBaron(at)co(dot)belcorp(dot)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'