Re: REINDEX VERBOSE DATABASE not working

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Em qua, 3 de jul de 2019 às 11:09, William Sescu (Suva) <william.sescu@xxxxxxx> 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

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux