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

[Lazaro Ruben Garcia Martinez]

The hash indexes are never write in the WAL. Your problem is for this reason, because Streaming replication uses the WAL for replication. 

Regards. 

----- "Armin Nesiren" <armin.nesiren at intera.si> escribió: 
> Also I found this on postgresql website: 

> 
http://www.postgresql.org/docs/9.0/static/indexes-types.html 

> 
"Caution 

Hash index operations are not presently WAL-logged, so hash indexes might need to be rebuilt with REINDEX after a database crash. They are also not replicated over streaming or file-based replication. For these reasons, hash index use is presently discouraged. " 
> 
> On Tue, Mar 22, 2011 at 4:59 PM, Armin Nesiren < armin.nesiren at intera.si > wrote: 
> 

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 
> 
> 

> -- 
> Armin 
> 
> _______________________________________________ Pgpool-general mailing list Pgpool-general at pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110322/6d61431a/attachment-0001.html>