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

Re: Any big slony and WAL shipping users?

From: "Josh Harrison" <joshques(at)gmail(dot)com>
To: "Glyn Astill" <glynastill(at)yahoo(dot)co(dot)uk>, simon(at)2ndquadrant(dot)com, ajs(at)crankycanuck(dot)ca
Cc: slony1-general(at)lists(dot)slony(dot)info, "General postgres mailing list" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Any big slony and WAL shipping users?
Date: 2007-12-28 17:06:42
Message-ID: 8d89ea1d0712280906o27a90666v553904feb45c9e3a@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
Hi,
Thanks for all your response.
I also thought abt having 2 setups for backup and replication so that even
when slony fails I will always have the standby server (WAL shipping) to
help me out.
 I have another question regarding this. I also want to write these to the
tape. Right now we have a cron job doing level 0,1,2,...  backups of the
other servers to the tape regularly. What is the good way to include
postgres server backup to tape?
Thanks
josh

On Dec 28, 2007 9:29 AM, Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk> wrote:

> 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(at)gmail(dot)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/
>
>

In response to

Responses

pgsql-general by date

Next:From: Josh HarrisonDate: 2007-12-28 17:23:21
Subject: Applying patch
Previous:From: Tom LaneDate: 2007-12-28 16:49:42
Subject: Re: double free corruption?

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