Re: REINDEX VERBOSE DATABASE not working

Поиск
Список
Период
Сортировка
От Fabrízio de Royes Mello
Тема Re: REINDEX VERBOSE DATABASE not working
Дата
Msg-id CAPfkCSB5wWjh5uabEj-uH8+km_wggLBYid9KE3UdSTeTRV0gsg@mail.gmail.com
обсуждение исходный текст
Ответ на REINDEX VERBOSE DATABASE not working  ("William Sescu (Suva)" <william.sescu@suva.ch>)
Ответы Re: REINDEX VERBOSE DATABASE not working
Список pgsql-admin
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 по дате отправления:

Предыдущее
От: "William Sescu (Suva)"
Дата:
Сообщение: RE: REINDEX VERBOSE DATABASE not working
Следующее
От: Standard Keyboard
Дата:
Сообщение: Fwd: Alternative to pg_lsclusters in RHEL/CentOS?