On Fri, Apr 6, 2012 at 1:35 AM, hans wulf <lotu1@xxxxxxx> 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. > > 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? No. If the WAL file which the standby requests doesn't exist in the pg_xlog directory of the master, replication just fails. In this case, you need to take a fresh base backup and start the standby from that backup. > 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? Or increase wal_keep_segments to high so that all WAL files which the standby requests are guaranteed to exist in the pg_xlog directory of the master. Regards, -- Fujii Masao -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
