On 19 September 2011 16:17, Tatsuo Ishii <ishii@xxxxxxxxxxxxxx> wrote:
> Hi,I personaly don't know any case study of pgpool and posgis but I
> do you know about any problems with using pgpool and postgis together?
guess:
1) You are using pgpool-II native replication mode
2) Some of postgis functions are doing updates/inserts/deletes
then you may have problem because of inconsistent data among DB
servers. Pgpool-II 3.0 or later can deal with the problem by using
"black and white function list" though.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
Thanks for the answer, I've forgotten about the couple of PostGIS functions that modify the data.
regards
Szymon
