News for hackers. Stuff that matters.
Re:SQLite the only database you will ever need in most cases by jeltz on Thursday April 15, 2021 @04:44AM (#26817791)
Are you sure? Since for PostgreSQL an atomic snapshot is enough. It is only when you do not have access to atomic snapshots that you strictly need to use the online backup api. And, yes, it will have to do a crash recovery when you first use the backup but if you cannot trust crash recovery you can't really trust your database at all.
Re:SQLite the only database you will ever need in most cases by mulander on Thursday April 15, 2021 @05:00AM (#26817928)
You are correct and what I had in mind was the required recovery. I do trust recovery but performing it can be very time consuming.