Are backups / live snapshots atomic?

I would like to know if DO live snapshots and backups are atomic. I mean, do they create a point in time snapshot of the file system?

I’m asking this because if live snapshots are atomic, then I can safely backup Postgresql data with a simple live snapshot on the server (indeed Postgresql uses WAL for transactions).


Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Hi @collimarco

The backups/snapshots are full server images of the point-in-time state, so not just file backup. Meaning when rolling back to that image, it will restore everything to that state - even running processes.

It’s generally not recommended to rely on full image backups as data-backup, but if you trust the PostgreSQL way of storing data in flat files, then yes, you can use it as backup for that.

I would highly recommend that you have other backup solutions as well - in other locations, so you’re safe in case of data center disaster.