Unfortunately the Internet is littered with ineffective methods of backing up your precious PostgreSQL database. Most methods use the pg_dumpall technique - this is inherently faulty for mission critical databases as it only creates plain text backups which would limit the restore options.
A better way is to use custom format backups coupled with global data backups (such as user accounts, permissions, etc):
No comments:
Post a Comment