Re: Postgres Clustering Options

Поиск
Список
Период
Сортировка
От Mikko Partio
Тема Re: Postgres Clustering Options
Дата
Msg-id 2ca799770911122332r4c2159c6uec0ed21ef0d0318a@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgres Clustering Options  (David Kerr <dmk@mr-paradox.net>)
Список pgsql-general

On Fri, Nov 13, 2009 at 1:47 AM, David Kerr <dmk@mr-paradox.net> wrote:
In your enviornment, are the applications able to recover automatically after
a DB failover?

For exmaple, we're using Java/JDBC connections +Geronimo we're researching whether
or not JDBC/Geronimo would be able to retry in the case of losing a connection to
the DB vs failing and crashing the app.


Since the system is active/passive, a failover *will* disconnect all sessions. We have coded our applications so that if they lose connection to the database, they will automatically try to reconnect.

Regards

Mikko

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

Предыдущее
От: Matt Sanchez
Дата:
Сообщение: Libpq binary mode SELECT ... WHERE ID IN ($1) Question
Следующее
От: silly8888
Дата:
Сообщение: Re: Libpq binary mode SELECT ... WHERE ID IN ($1) Question