postgis and pgpool

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

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 &lt;ishii@&gt; 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.