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