RE: REINDEX VERBOSE DATABASE not working

From: "William Sescu (Suva)" <william(dot)sescu(at)suva(dot)ch>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: RE: REINDEX VERBOSE DATABASE not working
Date: 2019-07-03 14:13:50
Message-ID: 8bd34f74f72848a69d959d4af6fcea23@suva.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I forgot to mention the version.

It is PostgreSQL 11.4 on Redhat 7.6

From: Sescu William (SW0)
Sent: Mittwoch, 3. Juli 2019 16:10
To: pgsql-admin(at)postgresql(dot)org
Subject: REINDEX VERBOSE DATABASE not working [mail signed OK]

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.

Cheers
William

________________________________

Disclaimer:

Diese Nachricht und ihr eventuell angehängte Dateien sind nur für den Adressaten bestimmt. Sie kann vertrauliche oder gesetzlich geschützte Daten oder Informationen beinhalten. Falls Sie diese Nachricht irrtümlich erreicht hat, bitten wir Sie höflich, diese unter Ausschluss jeglicher Reproduktion zu löschen und die absendende Person zu benachrichtigen. Danke für Ihre Hilfe.

This message and any attached files are for the sole use of the recipient named above. It may contain confidential or legally protected data or information. If you have received this message in error, please delete it without making any copies whatsoever and notify the sender. Thank you for your assistance.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Fabrízio de Royes Mello 2019-07-03 14:14:16 Re: REINDEX VERBOSE DATABASE not working
Previous Message William Sescu (Suva) 2019-07-03 14:09:36 REINDEX VERBOSE DATABASE not working