Re: 9.1.3 Standby catchup mode - Mailing list pgsql-general

From hans wulf
Subject Re: 9.1.3 Standby catchup mode
Date
Msg-id 20120408105104.190320@gmx.net
Whole thread Raw
In response to Re: 9.1.3 Standby catchup mode  (Michael Nolan <htfoot@gmail.com>)
Responses Re: 9.1.3 Standby catchup mode  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
> Why would you not want to maintain a WAL archive?  Are you depending on
> the
> slave server(s) as your only form of backup?

If the slave devide acts as a perfect backup, why would I need an additional 3rd entiy for WAL backups?

I know what the difference between sync and async is, but I don't see the need for a WAL archive in sync mode. Can you
pleaseexplain that? Thanks 


-------- Original-Nachricht --------
> Datum: Fri, 6 Apr 2012 17:54:54 -0400
> Von: Michael Nolan <htfoot@gmail.com>
> An: hans wulf <lotu1@gmx.net>
> CC: pgsql-general@postgresql.org
> Betreff: Re: [GENERAL] 9.1.3 Standby catchup mode

> On Thu, Apr 5, 2012 at 12:35 PM, hans wulf <lotu1@gmx.net> wrote:
>
> > I am wondering how the catchup mode of a hot synchron slave server works
> > on 9.1.3 if there is no WAL archive.
> >
>

>
> It isn't clear what you want from synchronous streaming replication, or if
> you understand the difference between synchronous streaming replication
> and
> asynchronous streaming replication.
> --
> Mike Nolan
--
NEU: FreePhone 3-fach-Flat mit kostenlosem Smartphone!
Jetzt informieren: http://mobile.1und1.de/?ac=OM.PW.PW003K20328T7073a

pgsql-general by date:

Previous
From: Michael Gould
Date:
Subject: Re: what Linux to run
Next
From: Adrian Klaver
Date:
Subject: Re: 9.1.3 Standby catchup mode