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

В списке pgsql-general по дате отправления:

Предыдущее
От: David Johnston
Дата:
Сообщение: Re: General guidance if there is an in dadabase solution or should stay as excel vba solution.
Следующее
От: Venkat Balaji
Дата:
Сообщение: Calculate Vacuum Metrics