Thread: postgis and pgpool

postgis and pgpool

From
Szymon Guz
Date:
Hi,
do you know about any problems with using pgpool and postgis together?

regards
Szymon

Re: postgis and pgpool

From
Tatsuo Ishii
Date:
> 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

Re: postgis and pgpool

From
Szymon Guz
Date:


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

Re: postgis and pgpool

From
gwainer
Date:
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.