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

2011-03-22 Thread Armin Nesiren
Thank you all for answers. On Tue, Mar 22, 2011 at 11:44 PM, Tatsuo Ishii 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

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

2011-03-22 Thread Tatsuo Ishii
> 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 configur

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

2011-03-22 Thread 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" escribió: > Also I found this on postgresql website: > http://www.postgresql.org/docs/9.0/static/indexes-types.html >

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

2011-03-22 Thread Guillaume Lelarge
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 stream

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

2011-03-22 Thread Armin Nesiren
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-

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

2011-03-22 Thread 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 Ri

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

2011-03-22 Thread Simon Riggs
On Tue, Mar 22, 2011 at 3:04 PM, Guillaume Lelarge 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 yo

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

2011-03-22 Thread Guillaume Lelarge
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

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

2011-03-22 Thread Armin Nesiren
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? -- Armin ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfound