Search Postgresql Archives

9.1.3 Standby catchup mode

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux