Skip site navigation (1) Skip section navigation (2)

Re: [Slony1-general] Any big slony and WAL shippingusers?

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Josh Harrison <joshques(at)gmail(dot)com>
Cc: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>, slony1-general(at)lists(dot)slony(dot)info, General postgres mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: [Slony1-general] Any big slony and WAL shippingusers?
Date: 2007-12-27 19:27:34
Message-ID: (view raw or whole thread)
Lists: pgsql-general
On Thu, 2007-12-27 at 12:49 -0500, Josh Harrison wrote:
> On Dec 27, 2007 12:37 PM, Andrew Sullivan <ajs(at)crankycanuck(dot)ca> wrote:
>         On Thu, Dec 27, 2007 at 10:49:10AM -0500, Josh Harrison wrote:
>         > Hi,
>         > We are trying to use slony and WAL shipping for warm standby
>         for replication
>         It's unusual to use both.  Any reason you want to?
> We wanted to have 1 master and 1 slave that can be queried and 1 warm
> standby server that can be brought up in case of crash.  So I thought
> it might be better to have WAL shipping for warm standby since thats
> working pretty good and Slony for master-slave replication. 
> Let me know your comments on this setup? What is better for this
> setup?

That's a setup I've recommended in the past.

It's like using RAC and Data Guard together, which is also common.

  Simon Riggs

In response to

pgsql-general by date

Next:From: Alvaro HerreraDate: 2007-12-27 20:27:30
Subject: Re: weird date/times in mailing list
Previous:From: Andrew SullivanDate: 2007-12-27 18:09:47
Subject: Re: [Slony1-general] Any big slony and WAL shipping users?

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group