Re: postgis and pgpool

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: mabewlun(at)gmail(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: postgis and pgpool
Date: 2011-09-19 14:17:50
Message-ID: 20110919.231750.1895066289604981242.t-ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-09-19 14:31:28 Re: Getting TOAST errors
Previous Message David Johnston 2011-09-19 14:17:17 Re: General guidance if there is an in dadabase solution or should stay as excel vba solution.