Streaming Replication and Hash Indices
| От | Seb Mel |
|---|---|
| Тема | Streaming Replication and Hash Indices |
| Дата | |
| Msg-id | 17792594-F751-46ED-BFBD-7FDF9092A6FA@mailz.de обсуждение исходный текст |
| Ответы |
Re: Streaming Replication and Hash Indices
|
| Список | 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 по дате отправления: