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

[Armin Nesiren]

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.

On Tue, Mar 22, 2011 at 4:48 PM, Simon Riggs <simon at 2ndquadrant.com> wrote:

> On Tue, Mar 22, 2011 at 3:04 PM, Guillaume Lelarge
> <guillaume at lelarge.info> wrote:
> > Le 22/03/2011 15:25, Armin Nesiren a écrit :
> >> I have problem reading from slave node values that is indexed with hash
> >> index.
> >>
> >> Does pgpool replicate hash indexes? Is there any special configuration
> for
> >> hash index?
> >>
> >
> > If you use pgpool replication system, you should have no issue with hash
> > index (or any other kind of index).
> >
> > The only replication system that has issue with hash index, AFAIK, is
> > the wal shipping of PostgreSQL.
> >
>
> Hash indexes aren't crash safe, meaning they become corrupt if the
> database crashes or someone does an immediate shutdown.
>
> You shouldn't be mixing high availability and hash indexes, whatever
> the weather.
>
> --
>  Simon Riggs                   http://www.2ndQuadrant.com/
>  PostgreSQL Development, 24x7 Support, Training & Services
>



-- 
Armin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110322/d3688f0a/attachment.html>