Re: REINDEX VERBOSE DATABASE not working

Em qua, 3 de jul de 2019 às 11:09, William Sescu (Suva) <
william(dot)sescu(at)suva(dot)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(at)[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(at)[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