Document that a CHECKPOINT before taking a file system snapshot can reduce recovery time. Patch attached and applied.
-- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +
diff --git a/doc/src/sgml/backup.sgml b/doc/src/sgml/backup.sgml index 3ce6fff..db7c834 100644 *** /tmp/eckWga_backup.sgml Wed Nov 24 18:40:43 2010 --- doc/src/sgml/backup.sgml Wed Nov 24 18:37:06 2010 *************** tar -cf backup.tar /usr/local/pgsql/data *** 383,388 **** --- 383,390 ---- on the backed-up data, it will think the previous server instance crashed and will replay the WAL log. This is not a problem; just be aware of it (and be sure to include the WAL files in your backup). + You can perform a <command>CHECKPOINT</command> before taking the + snapshot to reduce recovery time. </para> <para>
-- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs