[pgpool-general: 2039] Re: pgpool replication mode

[Tatsuo Ishii]

>> http://www.pgecons.org/wp-content/uploads/2013/04/Introducing_PostgreSQL_Enterprise_Consortium_activities.pdf
>> 
>> of page 21-22.
> 
> That is a great help, thank you. Which system would you recommend then?
> 
> 
>> 
>>> 2/How are things like nextval handled so that each backend is in synch? Especially when selects are load balanced.
>> 
>> SELECTs including nextval etc. are treated as if they are write
>> queries. i.e. they are load balanced.
>> 
> 
> Should that be 'not load balanced' or am I misunderstanding?

Sorry, I wanted to say "they are not load balanced".

> Do you have to set the blacklist for this treatment of nextval to function correctly?

Yes. However, that is already set in the default config file.

black_function_list = 'currval,lastval,nextval,setval'
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp