9.1.3 Standby catchup mode - Mailing list pgsql-general

From hans wulf
Subject 9.1.3 Standby catchup mode
Date
Msg-id 20120405163510.221310@gmx.net
Whole thread Raw
Responses Re: 9.1.3 Standby catchup mode  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: 9.1.3 Standby catchup mode  (Michael Nolan <htfoot@gmail.com>)
Re: 9.1.3 Standby catchup mode  (Fujii Masao <masao.fujii@gmail.com>)
List pgsql-general
I am wondering how the catchup mode of a hot synchron slave server works on 9.1.3 if there is no WAL archive.

Can the slave only request WALs that are still in the xlog directory of the master server? Or does the master
regeneratesome kind of fake log for the catchup mode? E.g. in case of a slave failure I could use a weekly backup and
letthe catchup mode do the rest? Or does that only work if you use WAL archive? 

The Doc says the following:

"When a standby first attaches to the primary, it will not yet be properly synchronized. This is described as catchup
mode.Once the lag between standby and primary reaches zero for the first time we move to real-time streaming state. The
catch-upduration may be long immediately after the standby has been created." 

I sounds as if the catchup mode has got magic powers, but I don't know if I'm readying the bible correctly.


--
NEU: FreePhone 3-fach-Flat mit kostenlosem Smartphone!
Jetzt informieren: http://mobile.1und1.de/?ac=OM.PW.PW003K20328T7073a

pgsql-general by date:

Previous
From: Vincent Dautremont
Date:
Subject: measure time intervals
Next
From: Adrian Klaver
Date:
Subject: Re: 9.1.3 Standby catchup mode