Thread: postgis and pgpool
Hi,
do you know about any problems with using pgpool and postgis together?
regards
Szymon
> 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
On 19 September 2011 16:17, Tatsuo Ishii <ishii@postgresql.org> 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
Hello, What PostGIS functions that modify data are you guys talking about? I'm new to PostGIS, and looking for advice when using it with PgPool for replication. I wonder if you know of any documentation about it. Thanks in advance, Gabriel Szymon Guz-2 wrote > > On 19 September 2011 16:17, Tatsuo Ishii <ishii@> wrote: > > Thanks for the answer, I've forgotten about the couple of PostGIS > functions > that modify the data. > > regards > Szymon > -- View this message in context: http://postgresql.1045698.n5.nabble.com/postgis-and-pgpool-tp4818521p5719256.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.