9.1.3 Standby catchup mode

From: "hans wulf" <lotu1(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: 9.1.3 Standby catchup mode
Date: 2012-04-05 16:35:10
Message-ID: 20120405163510.221310@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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 regenerate some kind of fake log for the catchup mode? E.g. in case of a slave failure I could use a weekly backup and let the 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-up duration 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2012-04-05 16:36:17 Re: BD impossible à recharger
Previous Message Alain 2012-04-05 16:25:44 Re: BD impossible à recharger

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2012-04-05 16:44:12 Re: patch: improve SLRU replacement algorithm
Previous Message Jeff Janes 2012-04-05 16:30:49 Re: patch: improve SLRU replacement algorithm