3 ms·
It is a PITA, but I've written scripts that pg_dump just the schema, load the schema into the new db with the new version, set up logical replication between th
by ttfkam 2y ago
It is a PITA, but I've written scripts that pg_dump just the schema, load the schema into the new db with the new version, set up logical replication between the two, wait for them to sync, reset all the sequences, and rebuild indexes before doing the handover.
It works with basically no downtime but I agree this kind of thing should definitely be easier, even turnkey.
- literalAardvark 2y agoI feel that really should be included in core, yes. I get why it wasn't, but logical replication has been production ready for a while now, so it really should have at least a little sugar.
- nijave 2y ago>should have at least a little sugar. I think that sums up PG pretty well. It seems there's a lot of things that lean into it the Unix "just use another tool" philosophy that ends up making management more difficult.