Re: postgis and pgpool
| От | Szymon Guz |
|---|---|
| Тема | Re: postgis and pgpool |
| Дата | |
| Msg-id | CAFjNrYsVHotjRQ41-hDiHm+FpOXfWG4dO3QSYTqzTbFu+rA9HQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: postgis and pgpool (Tatsuo Ishii <ishii@postgresql.org>) |
| Ответы |
Re: postgis and pgpool
|
| Список | pgsql-general |
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
В списке pgsql-general по дате отправления: