|
|
|
|
|
|
by whartung
1350 days ago
|
|
|
Thing is, in this specific context, as I understand it, this is much easier to do post 9.x. Notably, Postgres has more formal support for logical replication. Logical replication is distinct from the normal replication in that it forwards actual SQL to the replica rather than binary write ahead logs. The SQL is portable across versions more than WALs are. So with logical replication you can copy a live db to a new version. Then you just need some (ideally) brief down time to swap out the servers. There are solutions for 9.x, but it got much better later on. |
|
|