From 8366c7803ec3d0591cf2d1226fea1fee947d56c3 Mon Sep 17 00:00:00 2001 From: Simon Riggs Date: Wed, 25 Jan 2012 18:02:04 +0000 Subject: Allow pg_basebackup from standby node with safety checking. Base backup follows recommended procedure, plus goes to great lengths to ensure that partial page writes are avoided. Jun Ishizuka and Fujii Masao, with minor modifications --- doc/src/sgml/ref/pg_basebackup.sgml | 42 +++++++++++++++++++++++++++++++++++++ 1 file changed, 42 insertions(+) (limited to 'doc/src') diff --git a/doc/src/sgml/ref/pg_basebackup.sgml b/doc/src/sgml/ref/pg_basebackup.sgml index 05d5bedef93..c654a364124 100644 --- a/doc/src/sgml/ref/pg_basebackup.sgml +++ b/doc/src/sgml/ref/pg_basebackup.sgml @@ -64,6 +64,48 @@ PostgreSQL documentation better from a performance point of view to take only one backup, and copy the result. + + + pg_basebackup can make a base backup from + not only the master but also the standby. To take a backup from the standby, + set up the standby so that it can accept replication connections (that is, set + max_wal_senders and , + and configure host-based authentication). + You will also need to enable on the master. + + + + Note that there are some limitations in an online backup from the standby: + + + + + The backup history file is not created in the database cluster backed up. + + + + + There is no guarantee that all WAL files required for the backup are archived + at the end of backup. If you are planning to use the backup for an archive + recovery and want to ensure that all required files are available at that moment, + you need to include them into the backup by using -x option. + + + + + If the standby is promoted to the master during online backup, the backup fails. + + + + + All WAL records required for the backup must contain sufficient full-page writes, + which requires you to enable full_page_writes on the master and + not to use the tool like pg_compresslog as + archive_command to remove full-page writes from WAL files. + + + + -- cgit v1.2.3