News for hackers. Stuff that matters.
Re:SQLite is not a toy database (2021) by 5e92cb50239222b on Tuesday August 16, 2022 @02:02AM (#32479646)
FWIW, it's perfectly fine to backup both MariaDB and PostgreSQL by simply copying files. It's one of the recommended methods to set up PostgreSQL replicas:

https://www.postgresql.org/docs/current/continuous-archiving... (section 26.3.3.3)

You might want to configure the database to put binary logs into a separate directory (or you might want to leave them there, depends on your requirements).

Re:SQLite is not a toy database (2021) by stormdennis on Tuesday August 16, 2022 @03:10AM (#32480027)
Isn't that a bit different? As I understand it, he's talking about just copying the sql db file while you're talking about running a cluster wide backup tool to create a separate set of files, that you can then copy elsewhere as a backup.