Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hifxD-0006rU-Gj for pgsql-admin@arkaria.postgresql.org; Wed, 03 Jul 2019 14:09:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hifxC-0007o8-6q for pgsql-admin@arkaria.postgresql.org; Wed, 03 Jul 2019 14:09:46 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hifxB-0007mv-R6 for pgsql-admin@lists.postgresql.org; Wed, 03 Jul 2019 14:09:45 +0000 Received: from mailgw99.suva.ch ([195.65.221.20]) by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hifx4-0006Hy-Q0 for pgsql-admin@postgresql.org; Wed, 03 Jul 2019 14:09:45 +0000 From: "William Sescu (Suva)" To: "pgsql-admin@postgresql.org" Subject: REINDEX VERBOSE DATABASE not working Thread-Topic: REINDEX VERBOSE DATABASE not working Thread-Index: AdUxqMOpRYw9/nmwRLaAXQxqXliv7g== Date: Wed, 3 Jul 2019 14:09:36 +0000 Message-ID: Accept-Language: de-CH, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.93.103.200] MIME-Version: 1.0 Content-Type: multipart/signed; protocol="application/pkcs7-signature"; micalg="sha-256"; boundary="----7D19ABB0F9C229B145D376869A8A49E3" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is an S/MIME signed message ------7D19ABB0F9C229B145D376869A8A49E3 Content-Type: multipart/alternative; boundary="_000_da27115b57ec4109b68a5825f34df790suvach_" MIME-version: 1.0 --_000_da27115b57ec4109b68a5825f34df790suvach_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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 r= un 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 knowledge= base; 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 Adres= saten bestimmt. Sie kann vertrauliche oder gesetzlich gesch?tzte Daten oder= Informationen beinhalten. Falls Sie diese Nachricht irrt?mlich erreicht ha= t, 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 n= amed above. It may contain confidential or legally protected data or inform= ation. If you have received this message in error, please delete it without= making any copies whatsoever and notify the sender. Thank you for your ass= istance. --_000_da27115b57ec4109b68a5825f34df790suvach_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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 REIN= DEX

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&= quot;

LINE 1: REINDEX VERBOSE DATABASE knowledgebase;

        &nb= sp;       ^

 

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&uu= ml;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 n= amed above. It may contain confidential or legally protected data or inform= ation. 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.
--_000_da27115b57ec4109b68a5825f34df790suvach_-- ------7D19ABB0F9C229B145D376869A8A49E3 Content-Type: application/pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" MIIVPAYJKoZIhvcNAQcCoIIVLTCCFSkCAQExDTALBglghkgBZQMEAgEwCwYJKoZI hvcNAQcBoIISXDCCBWAwggNIoAMCAQICFHhYXy6tLBlL4zcHNTQTKLWW1GWTMA0G CSqGSIb3DQEBCwUAMEgxCzAJBgNVBAYTAkJNMRkwFwYDVQQKExBRdW9WYWRpcyBM aW1pdGVkMR4wHAYDVQQDExVRdW9WYWRpcyBSb290IENBIDEgRzMwHhcNMTIwMTEy MTcyNzQ0WhcNNDIwMTEyMTcyNzQ0WjBIMQswCQYDVQQGEwJCTTEZMBcGA1UEChMQ UXVvVmFkaXMgTGltaXRlZDEeMBwGA1UEAxMVUXVvVmFkaXMgUm9vdCBDQSAxIEcz MIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEAoL5QEI7p8mxAtASchbkx ytwt5BGpBDwbVcHnWDAdJLTD74XejCzhwT3fguZPrUeHbOxbScFK1buP7Iesf4Ka huw9A5lSAdI1nqza8FPJZjzUrAIB2iTTO6gCRq+kHOP4c1h2t/YOkA218M/M+vnG TOXDhjAKjRd+NevF37sOnMCNh+OIOIVn+j7Hq+ATnAUYmM+T9bGStPwj08/VxCdJ 4J48mwiji10qIeD8OapT2n1+zxoJU7xdBQTPoUqPi3aCDaH40scUd1uQNgeBmz4G +lJeY8WmAP6l6VIbUrWSOXIDCWK9sGAWbqbdJcIDZt3zBNFA4k6LhvRv5YOgJ4Re BMH1kL0wPcTvqGm8OJukpJbRYtppwAGWrsvEUTTqDKr/IY5Zj0pc5GGap9LpKniN UT06Fe6iWY6pXN7F+ZAi5YhFcd2RmWx6nz09mHxe9r4WaKBergsj/FoPqiJ2Lcmh EB3k00QjkIifxirm1/Was1geLzCJCBtUorWYI+wIdxyVXWHRy4mcX6JKkZrvIapJ FgiovWEoMcl0rYX22cWxi9HlEDJNX4sgOjxJHzOFWQ3bywl1Q2lz+2txffDfxEx9 xqMuyJV5y3Oijk5NJPte5AS+chumJy1JWpl611wJILd/lLlP8Q0cXohCGxG355Hb nmz0at+MBpgDrcwo76VH81MCAwEAAaNCMEAwDwYDVR0TAQH/BAUwAwEB/zAOBgNV HQ8BAf8EBAMCAQYwHQYDVR0OBBYEFKOX1vNeohDhq0WfPBdkPO4BcJzMMA0GCSqG SIb3DQEBCwUAA4ICAQAY+lt1/D56x193x8rfz1/DEsRAXdQyqrhq19UVFUaYI6Xm kFsYmUzjrUKjgjE2iM3p+8QElkiLAceNAc9bMwaWRmZ0HU/twba5tA1hzGN+1y53 jJYcKiNoa4VXdnAzE/7hT6Yjdxj6GozovWXJzz/0yRfc68e8wAQuLUYvaWbDG4/+ 7D7TypS/dgolDal7Ahyp0DtfC8CBOj1k4b+nLU69TcTYKcYiGNDFrHICgj+qOqI6 Ipcx3Qhjw3UUuWAoLVto4BapZoIjUfXrU9gxm3vpt51L64gWz/ldOIpJMI/t8esZ 9HcaMRhNZ1RsL29l+ds97CHsXvT0i8pgZVTRcWT0+aajgTM2M3HwpHhfTq2DId40 SY3oWayd8nZaNvIT9K/gCcdhKmz34J2uu4ZKKG8u7rR5zZAzw7N2+vXwbJ0BkPqe kPaccs9H2sMf5DUgU/JU0d9hg6YC4iU43oUyLV5zkFJdQsTOPUvh+RmEHdWiUMxB +0EUw73WyVqjY2YCgL0FOjtHnOwAJkz1iFG/qCN/GAewC+2LJqFk02FK61yf3rOv ZwOzH91tXWloaateOux8abzHO4VOnhW5tBVPw5V6WNfJbOlsufMpY160LPAtPe1a ZeCpW0DCSJmBbZ4fBio8ErSLD5uiJPCmjdZ64Eu2ZJZjlYTCSs0cLiSHM2DlwzCC BgAwggPooAMCAQICFC3Mf/7Q95NSNoq2VQLYGTrjHMlsMA0GCSqGSIb3DQEBCwUA MH0xCzAJBgNVBAYTAkNIMR4wHAYDVQRhDBVOVFJDSC1DSEUtMTEyLjIxMC4zNDkx JjAkBgNVBAoMHVF1b1ZhZGlzIFRydXN0bGluayBTY2h3ZWl6IEFHMSYwJAYDVQQD DB1RdW9WYWRpcyBTd2lzcyBBZHZhbmNlZCBDQSBHMzAeFw0xOTA1MjExMzU3MDha Fw0yMjA1MjExNDA3MDBaMIGDMQswCQYDVQQGEwJDSDEPMA0GA1UECAwGTHV6ZXJu MQ8wDQYDVQQHDAZMdXplcm4xDTALBgNVBAoMBFNVVkExHTAbBgNVBAMMFFdpbGxp YW0gU2VzY3UgKFN1dmEpMSQwIgYJKoZIhvcNAQkBFhV3aWxsaWFtLnNlc2N1QHN1 dmEuY2gwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQDHMdH2IiHcwkm7 tUgKqqcjDw4ufOHCm19xkHKpFqoVHjqHFvBREs7ASSONCj+Pt0Sb3y/HmbWXJgzC tU3D9DlYiwkzOoNt2vNxEEQcvEZi1VWYCJGxtN/QD3wnv3GYT9RPzzATDET97QCi wgcYqRWIMgvoC8xQzRIRfJt28Zlk14wRCs1cOFMJUkRWG/z5/Zgu8Bv+Govl1ueU 8PuR9w8QmCba6PArDYhUHZ0LKrKDAsw2IR7mBCnitv5cJBV5PAuvgiyq+9uMN/QI sx3vncge2YfEdyu1xkD3mkXvTmESrT8NUr3Tv+Asxb9n3S7BC/atFD/kdIJV3j/G CeIjgqvfAgMBAAGjggFvMIIBazAfBgNVHSMEGDAWgBQGbLPpz+A7cF0eebe+8PZt fTaIIjB3BggrBgEFBQcBAQRrMGkwOAYIKwYBBQUHMAKGLGh0dHA6Ly90cnVzdC5x dW92YWRpc2dsb2JhbC5jb20vcXZjaGFkZzMuY3J0MC0GCCsGAQUFBzABhiFodHRw Oi8vdXcub2NzcC5xdW92YWRpc2dsb2JhbC5jb20wTgYDVR0gBEcwRTBDBgkrBgEE Ab5YAWQwNjA0BggrBgEFBQcCARYoaHR0cDovL3d3dy5xdW92YWRpc2dsb2JhbC5j b20vcmVwb3NpdG9yeTATBgNVHSUEDDAKBggrBgEFBQcDBDA7BgNVHR8ENDAyMDCg LqAshipodHRwOi8vY3JsLnF1b3ZhZGlzZ2xvYmFsLmNvbS9xdmNoYWRnMy5jcmww HQYDVR0OBBYEFKbIpSk77HsRZcx/a5hkdBsOcGRmMA4GA1UdDwEB/wQEAwIFoDAN BgkqhkiG9w0BAQsFAAOCAgEAkrHypcm40S3Bt0vvySd7yuM0GUJeXl/3ydpWvO+4 SPgtaNFsz2doYGAANW6bgqiDLKNjH25KWzz70q/ytKGGKUm5XNjRtP3aLs8dYwUI KqWf3Edw8s1vRuhwpOueXyIOEnnJ7oV9nLtARU58lA1La89evdqZ6z1Qt8iWG9Td LYHvY0iqEQUOeoe5GMYoAfma230TVuGSPD5qUQE2xE8o76kS5/kUdMdMoGtACNCu LHDExdss3Ul8P/Wqm0lJ0AsHIr4leYDtQB+e2CsGjm4QzYolZ3wKEtjS05RYbseU 9S8iy+Atya2yVgsmDdxxDMoSKzT4ZorNWKgX9CKssobDlTu5mNg3HSi3LGxrGsCd 7piCJGH0GqdtIk6iGC/cxcndCQtrlOWljcTUv2ikF1IjPiVvou4C/6iZwOCUuAFV E0Cdrjl59P4x8d7KHqgiv+hA2yqTBvpls2OLGBhTuCjL8U9pQ4v+Q+rXQCbq1Z2j VRc6UeSR+dTLvfI0NfqL77a37DsWHT2rtO1AYYd0gZVB+1C+GR8L5OH9byxm6dK3 VYnIyd2bHHLL3RdZIxvvG0a2eicfoYkA5X2UvhpJ8d72h7DGghxgP5hfziaJYUJ8 B8X3F/EGqPkGLoZ/Bux2rjftXbc1NJ2qoLHfTI7ecd0PLQH5k7rok7mojxEYN6I6 FI0wggbwMIIE2KADAgECAhRB6J7TViFJyJS923ve3X7FacckkDANBgkqhkiG9w0B AQsFADBIMQswCQYDVQQGEwJCTTEZMBcGA1UEChMQUXVvVmFkaXMgTGltaXRlZDEe MBwGA1UEAxMVUXVvVmFkaXMgUm9vdCBDQSAxIEczMB4XDTE4MDIxMzEzNTEwN1oX DTI4MDIxMTEzNTEwN1owfTELMAkGA1UEBhMCQ0gxHjAcBgNVBGEMFU5UUkNILUNI RS0xMTIuMjEwLjM0OTEmMCQGA1UECgwdUXVvVmFkaXMgVHJ1c3RsaW5rIFNjaHdl aXogQUcxJjAkBgNVBAMMHVF1b1ZhZGlzIFN3aXNzIEFkdmFuY2VkIENBIEczMIIC IjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEA329pdBtbr7lHwGdxzEJH91mA nkWzHXLckl5mhgxX2cEc1AS3GqWjGBfoZmWwO1ORIRh0xxjM4gqSD1K94oSdkGvU JDqzM1bTtmzrVFrUiORzVMVjpZjGshmZuxFDekd7dS9poW2Lfsqx58uf/Qqg4rNa cAZv8tAavzaXCUSWEvOm/26jp6pad28aDoP+2y03jfkS2svKx1JT9ZjqUi/cWbW5 RubZNGehq9YcQTR/UmAKs7qNd07bwVgnZ0sD4U45dg07T/URRwVg0BfUxqX4/1ov fVW/Ezcnm684IbPCvUUFLUfMc+hEdvUJA+9gEgxBXDrlaQMcAamCznyFpQcgF+CA 9iAxNHhe1iAvDxR4YchjBI27jg27zNd2QOq37V4/jg1yTAy7TrAjvczwWhXsdqhK nj/H43ogifK8NC7noXxmecciRdRwyVlhs4BZGTNzS0bAsRnVOzPp6hyYCtu9oU9Q W6GdJkUY7qc67vP0w05bP0qic4HQShmXunrvA3MjLQeLlNbShdsL+IAVKqZ5kGO5 EXPNPls2zW5wfyQAzmBeV3MfelEbutH6PryonKa51WJB3PLPXZEW3ub3ccOBZOl0 +mHVPLC9VOn+Jl0Yop3KvstNzAQ4t4kujuh5u8e2LgRL6GquWduLM11DSPHfVDvO VowzFPOFqFi6i9+mCM0CAwEAAaOCAZswggGXMBIGA1UdEwEB/wQIMAYBAf8CAQAw HwYDVR0jBBgwFoAUo5fW816iEOGrRZ88F2Q87gFwnMwwdAYIKwYBBQUHAQEEaDBm MDgGCCsGAQUFBzAChixodHRwOi8vdHJ1c3QucXVvdmFkaXNnbG9iYWwuY29tL3F2 cmNhMWczLmNydDAqBggrBgEFBQcwAYYeaHR0cDovL29jc3AucXVvdmFkaXNnbG9i YWwuY29tMEkGA1UdIARCMEAwPgYEVR0gADA2MDQGCCsGAQUFBwIBFihodHRwOi8v d3d3LnF1b3ZhZGlzZ2xvYmFsLmNvbS9yZXBvc2l0b3J5MDMGA1UdJQQsMCoGCCsG AQUFBwMCBggrBgEFBQcDBAYKKwYBBAGCNwoDDAYIKwYBBQUHAwkwOwYDVR0fBDQw MjAwoC6gLIYqaHR0cDovL2NybC5xdW92YWRpc2dsb2JhbC5jb20vcXZyY2ExZzMu Y3JsMB0GA1UdDgQWBBQGbLPpz+A7cF0eebe+8PZtfTaIIjAOBgNVHQ8BAf8EBAMC AQYwDQYJKoZIhvcNAQELBQADggIBAGUd5HwFhK7lhaX0dd1QfDyKeDum1bFFphRm kJUMUnY0f+kfLwu4EEzpFZ1Bz6UMREnC1kVgkLj1bpqFPX6XB0AvCjcbPmMAWYrk 8H/3PcJ0LxwK3uwAWXPeS1R1o3QV9OBALnRRNpfqdcSSVFs8kaaX36OQiQhqGtTK 6YcGG0quRENym/ZRVMRoOmNsbcaUc3hSPTzRqMF7VPV2vGqqrnwzW74pxzKSneoW W96dfjZ80gV6Shx/x6xb/g/pYdQQLriPqLP0dgvPt7iESXHEmHY4rzwxVlHYKPJB QhXA0f+6yUE4UaV1RNVnMCeQGRS1HL9KyK3v8/AFWxW9akiBV0ROqRw6A/q7iWIc RKaxilm7scN6cCWty6W1Y26dJ6Xlb5QuIUZhYbPQuWMOSwOVTvcaU+zPfeJzcTlO u/dg+ZCGrXd5lx1S5exROVA5SnnZmzSc7L0BiInhLeLg9EGHz92a9yBAuOcMmOMh uCiU52LFFxeU6as1Ulm4QvJLdj3GOu2VWopArGE2M2Mj+ydBoes7q62dkmJZQP1R QgI8Owi/oyoQEvDQt9IDcSoFf3hHn7KCTjj1TWlGmUtyC7kA5gjcJ6IDxkEke5o6 0zQSXP885OybmWs/Ggs6TR6VWTQO1xr323Wned72KieH8L/qAWRHJx+EN9HnCAtE 5x0DMCDrMYICpjCCAqICAQEwgZUwfTELMAkGA1UEBhMCQ0gxHjAcBgNVBGEMFU5U UkNILUNIRS0xMTIuMjEwLjM0OTEmMCQGA1UECgwdUXVvVmFkaXMgVHJ1c3RsaW5r IFNjaHdlaXogQUcxJjAkBgNVBAMMHVF1b1ZhZGlzIFN3aXNzIEFkdmFuY2VkIENB IEczAhQtzH/+0PeTUjaKtlUC2Bk64xzJbDALBglghkgBZQMEAgGggeQwGAYJKoZI hvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMTkwNzAzMTQwOTM3 WjAvBgkqhkiG9w0BCQQxIgQgaTIuEkh1SL7Mjj5Ue1d+m4yCjkkzfGK4inzzU2DS hEYweQYJKoZIhvcNAQkPMWwwajALBglghkgBZQMEASowCwYJYIZIAWUDBAEWMAsG CWCGSAFlAwQBAjAKBggqhkiG9w0DBzAOBggqhkiG9w0DAgICAIAwDQYIKoZIhvcN AwICAUAwBwYFKw4DAgcwDQYIKoZIhvcNAwICASgwDQYJKoZIhvcNAQEBBQAEggEA UFoBPKfsnGLNZTNXhbBqsy9JVoyelVW6ho3yp3wjQtwLbTgpMX2H0G5N6VCN07fq AWtSEcOu8JKpNMD6LD4EySyzZJ/CuOFD4QKN8kyl3OBkO6fV6xJkTPBn6Wr/YGtL rbs79JxoJFzNifkIVUc0vew4SZqP8MyEPTdZf250uocRtHSjCitMqfZ4TXIX9kYE KBnri3rN1YKqvllyJ5zgDhymyRjabwSkgj6aJxXkMoghbxzoZ0HFXy2/QMlhfJAe ngaZPIYZXTJ0UCYW1rHkS4vfMJdkmUIAMX1oTrpOfqISEhz+hEXSdARGoS7gN3Kw XY2OxKEBehAtfx6HQvyyKA== ------7D19ABB0F9C229B145D376869A8A49E3--