Streaming Replication and Hash Indices

From: Seb Mel <webmaster(at)mailz(dot)de>
To: pgsql-docs(at)postgresql(dot)org
Subject: Streaming Replication and Hash Indices
Date: 2016-01-18 12:15:28
Message-ID: 17792594-F751-46ED-BFBD-7FDF9092A6FA@mailz.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Hi list,

today i got bitten by the issue that streaming replication does not replicate "hash" indices as those changes are not written to WAL. That fact is documented 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 would make you into thinking that the issue was fixed.
That is wrong though, as it will reappear after some time when the data in the table and the index diverge :)!

Regards,
Seb

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Igal @ Lucee.org 2016-01-18 20:52:31 system mingw not recognized
Previous Message Michael Paquier 2016-01-18 06:10:42 Re: pg_extension_config_dump() function and sequences