| From: | Mikko Partio <mpartio(at)gmail(dot)com> |
|---|---|
| To: | David Kerr <dmk(at)mr-paradox(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Postgres Clustering Options |
| Date: | 2009-11-13 07:32:39 |
| Message-ID: | 2ca799770911122332r4c2159c6uec0ed21ef0d0318a@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Nov 13, 2009 at 1:47 AM, David Kerr <dmk(at)mr-paradox(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Valtonen, Hannu | 2009-11-13 07:44:35 | Re: pgmemcache vs pgmemcached |
| Previous Message | Guillaume Lelarge | 2009-11-13 07:32:20 | Re: [GENERAL] CREATE TABLE LIKE and SERIAL |