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