News for hackers. Stuff that matters.

A comment on What if we treated Postgres like SQLite?. Parent comment

Re:What if we treated Postgres like SQLite? by OutOfHere on Monday September 22, 2025 @03:02PM (#45337960)
I would never ever zip up a PostgreSQL data directory and expect it to restore elsewhere. I would use a proper export. If the export is too slow, it could help to use streaming replication to write intermediate files which can be moved to a backup location.

Even with SQLite, for a simple file copy to work reliably, one has to set these three:

  "_pragma=synchronous(FULL)",
  "_pragma=checkpoint_fullfsync(ON)",
  "_pragma=fullfsync(ON)",
[ Parent | on HN ]
Re:What if we treated Postgres like SQLite? by markusw on Monday September 22, 2025 @03:09PM (#45338044)
Agreed about the Postgres export!

For sqlite, I would recommend "sqlite3 app.db '.backup backup.db'" though, if that's an option. Guaranteed consistent!

[ Parent | on HN ]