Postgres Pro
Downloads
Home   >   mailing lists

Re: REINDEX VERBOSE DATABASE not working - Mailing list pgsql-admin

From Fabrízio de Royes Mello
Subject Re: REINDEX VERBOSE DATABASE not working
Date
Msg-id CAPfkCSB5wWjh5uabEj-uH8+km_wggLBYid9KE3UdSTeTRV0gsg@mail.gmail.com
Whole thread Raw
In response to REINDEX VERBOSE DATABASE not working  ("William Sescu (Suva)" <william.sescu@suva.ch>)
Responses Re: REINDEX VERBOSE DATABASE not working  (Avin Kavish <avinkavish@gmail.com>)
List pgsql-admin
Tree view
Em qua, 3 de jul de 2019 às 11:09, William Sescu (Suva) <william.sescu@suva.ch> escreveu:

Hello %

 

Regarding the Docs

 

https://www.postgresql.org/docs/11/sql-reindex.html

 

and due to the REINDEX syntax, I should be able to specify VERBOSE when I run the REINDEX command, to print a progress report.

 

(postgres@[local]:55000)[knowledgebase]> \h REINDEX

Command:     REINDEX

Description: rebuild indexes

Syntax:

REINDEX [ ( VERBOSE ) ] { INDEX | TABLE | SCHEMA | DATABASE | SYSTEM } name

 

But it is not working.

 

(postgres@[local]:55000)[knowledgebase]> REINDEX VERBOSE DATABASE knowledgebase;

ERROR:  syntax error at or near "VERBOSE"

LINE 1: REINDEX VERBOSE DATABASE knowledgebase;

                ^

 

Can somebody help me out regarding this issue.

 


Your syntax is wrong. Try:

REINDEX (VERBOSE) DATABASE knowledgebase;

Regards

--
   Fabrízio de Royes Mello         Timbira - http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

pgsql-admin by date:

Previous
From: "William Sescu (Suva)"
Date:
Subject: RE: REINDEX VERBOSE DATABASE not working
Next
From: Standard Keyboard
Date:
Subject: Fwd: Alternative to pg_lsclusters in RHEL/CentOS?