On Wed, Aug 09, 2023 at 10:19:09AM -0500, Les Mikesell wrote:

[...]

> Databases can be a problem because they update all the time so you may not
> get a consistent snapshot unless you use the tool specific to the database
> to perform a consistent dump to a file, then let backuppc back that up.

[...]

With the right DBMS and a little bit of setup, rsync is a perfectly fine
way of backing up your databases [1]. Even with the wrong DBMS, all it
takes is an SQL dump and backing up that (might be expensive with a couple
o' 100M records, though).

Cheers

[1] https://www.postgresql.org/docs/current/continuous-archiving.html

-- 
t

Attachment: signature.asc
Description: PGP signature

_______________________________________________
BackupPC-users mailing list
BackupPC-users@lists.sourceforge.net
List:    https://lists.sourceforge.net/lists/listinfo/backuppc-users
Wiki:    https://github.com/backuppc/backuppc/wiki
Project: https://backuppc.github.io/backuppc/

Reply via email to