From: Seb Mel <webmaster@mailz.de>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Subject: Streaming Replication and Hash Indices
Message-Id: <17792594-F751-46ED-BFBD-7FDF9092A6FA@mailz.de>
Date: Mon, 18 Jan 2016 13:15:28 +0100
To: pgsql-docs@postgresql.org
Mime-Version: 1.0 (Mac OS X Mail 8.2 \(2104\))
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

Hi list,

today i got bitten by the issue that streaming replication does not replica=
te "hash" indices as those changes are not written to WAL. That fact is doc=
umented here:
http://www.postgresql.org/docs/current/static/indexes-types.html

But i could not find that information anywhere else like:
https://wiki.postgresql.org/wiki/Streaming_Replication#Restrictions
or
http://www.postgresql.org/docs/current/static/warm-standby.html

I suppose it would be very helpful to add it there, as the usual policy for=
 "corrupt slave data" is to recreate the slave from a base_backup which wou=
ld make you into thinking that the issue was fixed.=20
That is wrong though, as it will reappear after some time when the data in =
the table and the index diverge :)!

Regards,
Seb

--=20
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs