From ca2d08579e27192867a421ab2c324c8c0c6b2440 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Thu, 17 Mar 2005 05:03:37 +0000 Subject: [PATCH] Document use of rsync for file system backups. Tino Wildenhain --- doc/src/sgml/backup.sgml | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) diff --git a/doc/src/sgml/backup.sgml b/doc/src/sgml/backup.sgml index 02d07f6c2f..00efde7ee2 100644 --- a/doc/src/sgml/backup.sgml +++ b/doc/src/sgml/backup.sgml @@ -1,5 +1,5 @@ Backup and Restore @@ -373,6 +373,15 @@ tar -cf backup.tar /usr/local/pgsql/data establish all the frozen snapshots. + + 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. + + Note that a file system backup will not necessarily be smaller than an SQL dump. On the contrary, it will most likely be -- 2.50.0