documention of checkpoints with file system snapshots - Mailing list pgsql-docs

From Bruce Momjian
Subject documention of checkpoints with file system snapshots
Date
Msg-id 201011242342.oAONgH123174@momjian.us
Whole thread Raw
List pgsql-docs
Document that a CHECKPOINT before taking a file system snapshot can
reduce recovery time.  Patch attached and applied.

--
  Bruce Momjian  <bruce@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>

pgsql-docs by date:

Previous
From: Thom Brown
Date:
Subject: Re: Additional index entries and table sorting
Next
From: Bruce Momjian
Date:
Subject: Re: [PATCH] Fix documentation about PL/Python exception handling