From: | <marin(at)kset(dot)org> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Missing WALs when doing pg_basebackup from slave... |
Date: | 2015-06-10 08:47:03 |
Message-ID: | 90e04973bfb90e7b7f8b1f5513e4501e@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have been testing a master slave configuration of PostgreSQL 9.4.2 using
streaming replciation. The master is initialised with a blank database and
the slave is created with a pg_start_backup()/rsync/pg_stop_backup()
procedure. The slave connects to the master and works flawlessly. For
testing purposes backup is configured to run every 5 minutes from the
master on one location, and from the slave on an other location. The backup
procedure is done using pg_basebackup with the --xlog-method=stream to
fetch all WALs that are needed for the backup to be fully functional.
I left it running for a day. A few backups that were made from the slave
didn't contain any WAL files (only history files in complex cases when the
master had switched to a newer timeline).
Is it normal that pg_basebackup runs successfully (rc=0) and there is no
WAL files present?
The master and slave are sitting idle, after only a few transaction on the
master at the beginning of the day. I noted that all WAL switches are
caused by the backup running on the master. Is it possible the slave is in
a consistent state when it has applied all changes from the previous WAL
and the new WAL hasn't been created yet on the master (so actually no WAL-s
are needed to restore it to a consistent state)?
Regards,
Mladen Marinović
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2015-06-10 15:43:19 | Re: Indexed views like SQL Server - NOT Materialized Views |
Previous Message | William Dunn | 2015-06-10 06:56:30 | Re: Indexed views like SQL Server - NOT Materialized Views |