Index: doc/src/sgml/backup.sgml =================================================================== RCS file: /cvsroot/pgsql/doc/src/sgml/backup.sgml,v retrieving revision 2.58 diff -c -c -r2.58 backup.sgml *** doc/src/sgml/backup.sgml 17 Mar 2005 05:10:11 -0000 2.58 --- doc/src/sgml/backup.sgml 17 Mar 2005 15:26:23 -0000 *************** *** 364,372 **** ! If your database is spread across multiple volumes (for example, ! if you are using tablespaces) there may not be any way ! to obtain exactly-simultaneous frozen snapshots of all the volumes. Read your file system documentation very carefully before trusting to the consistent-snapshot technique in such situations. The safest approach is to shut down the database server for long enough to --- 364,374 ---- ! If your database is spread across multiple file systems there may not ! be any way to obtain exactly-simultaneous frozen snapshots of all ! the volumes. For example, if your data files and WAL log on different ! file disks, or if tablespaces are on different file systems, it might ! not be possible to use snapshots because the snapshots must be simultaneous. Read your file system documentation very carefully before trusting to the consistent-snapshot technique in such situations. The safest approach is to shut down the database server for long enough to *************** *** 375,385 **** Another option is to use rsync to perform a file ! system backup. First, while the database server is running, ! run rsync, then shut down the database ! server and perform a second rsync, then ! restart the database server. This allows a file system backup to be ! performed with minimal downtime. --- 377,388 ---- Another option is to use rsync to perform a file ! system backup. This is done by first running rsync ! while the database server is running, then shutting down the database ! server just long enough to do a second rsync. The ! second rsync will be much quicker than the first, ! but will be consistent because the server was down. This method ! allows a file system backup to be performed with minimal downtime.