On 19 September 2011 16:17, Tatsuo Ishii <is...@postgresql.org> wrote:
> > Hi, > > do you know about any problems with using pgpool and postgis together? > > I personaly don't know any case study of pgpool and posgis but I > 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