One of the first things I worry about when I’m looking at a new system is the status of the backups. I don’t see anything in PostgreSQL that will lead me to a different conclusion. However, I didn’t realize just how big a can of worms I would open by pursuing backups and restores.
Instead of talking immediately about backups, let’s talk about restores.
This is a bit different from what we’re used to in SQL Server, so definitely check it out if you are looking at Postgres development or administration.