Re: Any big slony and WAL shipping users? - Mailing list pgsql-general

From Glyn Astill
Subject Re: Any big slony and WAL shipping users?
Date
Msg-id 361160.36878.qm@web25812.mail.ukl.yahoo.com
Whole thread Raw
In response to Any big slony and WAL shipping users?  ("Josh Harrison" <joshques@gmail.com>)
Responses Re: Any big slony and WAL shipping users?
List pgsql-general
Hi Josh,

This is exactly the same setup I'm currently testing. For those
asking why use both WAL shipping and slony, it's simple; this means
we have no single point of failure. If slony stops replicating
because we mess up a replication set or our shipping method (NFS)
falls on its ass, at least we still have some replication going.

We have to use slony, like you we need a replica to take the load off
of our main system, this is mainly for our reporting processes.

Glyn


--- Josh Harrison <joshques@gmail.com> wrote:

> Hi,
> We are trying to use slony and WAL shipping for warm standby for
> replication
> with postgresql. Currently our systems are in oracle and we r
> checking the
> feasibility to migrate to postgres. Replication is one major issue
> here.
> Though everything seems to be working fine in our test environment,
> we just
> want the assurance that Slony and WAL shipping is used by other
> large
> production systems and running successfully.
> What are the other large 24x7 productions systems that use slony
> and the
> other WAL archiving of postgresql successfully?
>
> Thanks
> josh
>



      ___________________________________________________________
Yahoo! Answers - Got a question? Someone out there knows the answer. Try it
now.
http://uk.answers.yahoo.com/


pgsql-general by date:

Previous
From: "Leonel Nunez"
Date:
Subject: Re: Red Hat 9
Next
From: Andrew Sullivan
Date:
Subject: Re: [Slony1-general] Any big slony and WAL shipping users?