Approaches to PostgreSQL Replication and Backup

Re:Approaches to PostgreSQL Replication and Backup by rosser on Friday February 23, 2018 @11:57PM (#16451766)

> In many such cases you'll still want to pull backups anyway...

In all cases where you care about your data, you must take backups. There is no substitute for that step.

Additionally, you want to periodically restore your backups and test them for validity — ideally automatically. There's a saying in the ops world, borne of bitter experience:

"Your backups are only as good as their last successful restore."

[ Parent | on HN ]

Re:Approaches to PostgreSQL Replication and Backup by colanderman on Saturday February 24, 2018 @10:15AM (#16453545)

What grantwu said. You misinterpreted me. Seems to be a theme today. I guess I should spell things out more clearly in the future.

[ Parent | on HN ]

Re:Approaches to PostgreSQL Replication and Backup by rosser on Saturday February 24, 2018 @05:19PM (#16455775)

Ok, my apologies. I've never heard that phrasing before, but now that you clarify, I understand it.

Ambiguity in online discourse is an ongoing problem. Thanks for helping resolve this occurrence without acrimony.

[ Parent | on HN ]

Re:Approaches to PostgreSQL Replication and Backup by grantwu on Saturday February 24, 2018 @02:30AM (#16452210)

I read "pull backups" as "restore from backup" not "make backups".

[ Parent | on HN ]