News for hackers. Stuff that matters.
Re:Zero downtime Postgres migration, done right by sharadov on Friday June 11, 2021 @01:12PM (#27475953)
pg_upgrade with --hard-link option will upgrade the db in mins, I've done a 2TB db in less than a minute. Yes, there is no rollback, but if you do enough testing prior it can be really smooth. Am in the middle of doing this across an environment where we have tens of hosts from a few GB to couple TB.
Re:Zero downtime Postgres migration, done right by zozbot234 on Friday June 11, 2021 @03:48PM (#27477638)
You could take a filesystem-level snapshot for rollback.