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

Re: [linux-lvm] PostgreSQL and file system level backup



Which gives rise to my present question: given that LVM DOES give an
instantaneous snapshot of the filesystem, would an xfsdump of an LVM
snapshot of an XFS filesystem give usable backups?

PS: Our databases have crossed the 100 GB size, with some tables reaching
25 GB, so pg_dump is taking more than 5 hours to complete (changing the
level of compression in custom format dump files from 6 to 1 did not
significantly reduce the dump duration). Otherwise, pg_dump-ing the
database (and copying the .conf files) was just dandy.

LVM won't give you any more stable of a pictire over 5 hours than anything else will unless you shut dwon the database first. Even if you try it once and the process works you are just as likely to be bit my Murphy on the next trial.

Alternatives:

	Use a mirror for the database, split it, and use that
	copy for a backup. This is a common procedure in data
	warehousing.

	Make incremental backups of the daily loads and only
	perform a full backup on, say, weekends at 0300; use
	RAID5 or mirroring to minimimize the odds of having to
	restore anything.
	
	You may be able to dump portions of the
	database in parallel to decrease the time (this
	requires careful partitioning of the space).

--
Steven Lembark                               2930 W. Palmer
Workhorse Computing                       Chicago, IL 60647
                                           +1 800 762 1582



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