| From: | Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info> |
|---|---|
| To: | Bruno Wolff III <bruno(at)wolff(dot)to> |
| Cc: | Sebastian Reitenbach <itlistuser(at)rapideye(dot)de>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: postgres in HA constellation |
| Date: | 2006-10-04 16:05:02 |
| Message-ID: | 1159977902.15773.37.camel@dba5.int.libertyrms.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Wed, 2006-10-04 at 10:43 -0500, Bruno Wolff III wrote:
> On Wed, Oct 04, 2006 at 11:23:45 -0000,
> Sebastian Reitenbach <itlistuser(at)rapideye(dot)de> wrote:
> If you have multiple data centers to protect against disaster, then you might
> look at SLONY which you can use to replicate to a slave system. However, I
> think it is possible for the master to report a transaction as commited
> before it is shipped off to the slave, so that if the master fails you might
> lose some transactions when switching to the slave. But double check with
> the SLONY documentation on this.
This is indeed accurate, and highly likely to happen if you need to do a
fail over. It all depends on the level of activity.
Brad.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | n0g0013 | 2006-10-04 16:37:26 | non-standard 'CREATE INDEX' problem |
| Previous Message | Bruno Wolff III | 2006-10-04 15:54:59 | Re: Recursive use |