[Pgpool-general] hash index - does not work from slave.

Armin Nesiren armin.nesiren at intera.si
Tue Mar 22 22:49:05 UTC 2011


Thank you all for answers.


On Tue, Mar 22, 2011 at 11:44 PM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:

> > Le 22/03/2011 16:59, Armin Nesiren a écrit :
> >> But, what am I doing wrong then.
> >> When I insert something in master node, and after that take select, I
> see my
> >> record.
> >>
> >> On slave, when using index I can not see exact record, and without using
> >> index, record is there.
> >> I have configured streaming replication.
> >>
> >
> > Streaming replication doesn't replicate hash index changes because they
> > aren't logged in the WALs.
>
> Right. I will add this to pgpool-II FAQ.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110322/48414711/attachment.html>


More information about the Pgpool-general mailing list