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: | REINDEX VERBOSE DATABASE not working |
Date: | 2019-07-03 14:09:36 |
Message-ID: | da27115b57ec4109b68a5825f34df790@suva.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | William Sescu (Suva) | 2019-07-03 14:13:50 | RE: REINDEX VERBOSE DATABASE not working |
Previous Message | Mark Steben | 2019-07-02 21:31:38 | Re: pg_xlog no longer rotating out |