Re: postgis and pgpool - Mailing list pgsql-general

From Tatsuo Ishii
Subject Re: postgis and pgpool
Date
Msg-id 20110919.231750.1895066289604981242.t-ishii@sraoss.co.jp
Whole thread Raw
In response to postgis and pgpool  (Szymon Guz <mabewlun@gmail.com>)
Responses Re: postgis and pgpool
List pgsql-general
> 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

pgsql-general by date:

Previous
From: "David Johnston"
Date:
Subject: Re: General guidance if there is an in dadabase solution or should stay as excel vba solution.
Next
From: Tom Lane
Date:
Subject: Re: Getting TOAST errors