From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: andreibancila@yahoo.com
Subject: reindex database
Date: Sun, 28 Jun 2020 20:42:10 +0000
Message-ID: <159337693095.683.13638770130415272902@wrigleys.postgresql.org> (raw)
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/sql-reindex.html
Description:
Hello,
I am using this command to reindex the databases for a PostgreSQL 10
cluster.
What I can not find in the reindex explanation page is how is this affecting
the standby database. I tracked the log creation on the Primary cluster but
I saw nothing like this on the Standby cluster.
I was able to find the following statement on the hot-standby description
page (26.5. Hot Standby) from the documentation:
"As a result, you cannot create additional indexes that exist solely on the
standby, nor statistics that exist solely on the standby. If these
administration commands are needed, they should be executed on the primary,
and eventually those changes will propagate to the standby."
(https://www.postgresql.org/docs/10/hot-standby.html)
Can you please tell me more on this topic or point me to the documentation
page that explained more on this topic (database reindex - synching with the
standby cluster and impact on the standby cluster).
Thank you,
Andrei Bancila
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, andreibancila@yahoo.com
Subject: Re: reindex database
In-Reply-To: <159337693095.683.13638770130415272902@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox