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'