News for hackers. Stuff that matters.

A comment on Why Does Everyone Run Ancient Postgres Versions?. Parent comment

Re:Why Does Everyone Run Ancient Postgres Versions? by ttfkam on Friday October 18, 2024 @10:08AM (#41879618)
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.

[ Parent | on HN ]
Re:Why Does Everyone Run Ancient Postgres Versions? by literalAardvark on Friday October 18, 2024 @03:34PM (#41882711)
I 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.

[ Parent | on HN ]
Re:Why Does Everyone Run Ancient Postgres Versions? by nijave on Saturday October 19, 2024 @04:54PM (#41890711)
>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.

[ Parent | on HN ]