Vacuum into or .backup work perfectly with a running, WAL enabled db.
At which point there’s little difference from any other database’s backup commands.
alt Hacker News
At which point there’s little difference from any other database’s backup commands.