[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [rdiff-backup-users] Backup of changing files

From: rdiff
Subject: Re: [rdiff-backup-users] Backup of changing files
Date: Mon, 16 Apr 2007 14:56:27 -0700 (PDT)

On Fri, 30 Mar 2007, Baldur Norddahl wrote:
I want to use rdiff-backup with my Postgresql database. The problem is that the tool refuses to backup files that are changing.

We simply pg_dumpall > /backup/sqldump.sql and then rdiff-backup the /backup directory. Then you don't have to worry about changing files, and rdiff works /really/ well on text files :)


The database is live and modifying the database files during the backup. This is fine, because I am using the PITR (point in time recovery) feature of Postgresql.

Using rsync works fine for this purpose. The database files will naturally be damaged on the target, because they changed during the copy. However, the database will create journal log files which can then be used to repair the backup.

All I need is a switch that tells rdiff-backup that it is ok that the target files will not be consistent.

I am aware of an earlier thread on this mail list, which proposes using LVM for freezing the source while doing the backup. This will indeed work for my purpose, but will require extensively reconfiguration of my setup and should be unnecessary. Even using LVM, my backup will be in an invalid state (it equals to a database crash). The LVM option adds a lot of complexity for little gain.



rdiff-backup-users mailing list at address@hidden
Wiki URL: http://rdiff-backup.solutionsfirst.com.au/index.php/RdiffBackupWiki

reply via email to

[Prev in Thread] Current Thread [Next in Thread]