Streaming Replication and Hash Indices - Mailing list pgsql-docs

From Seb Mel
Subject Streaming Replication and Hash Indices
Date
Msg-id 17792594-F751-46ED-BFBD-7FDF9092A6FA@mailz.de
Whole thread Raw
Responses Re: Streaming Replication and Hash Indices  (Bruce Momjian <bruce@momjian.us>)
List pgsql-docs
Hi list,

today i got bitten by the issue that streaming replication does not replicate "hash" indices as those changes are not
writtento 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
slavefrom 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

pgsql-docs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: pg_extension_config_dump() function and sequences
Next
From: "Igal @ Lucee.org"
Date:
Subject: system mingw not recognized