Seems like this PgSQL upgrade from 9.6 to 11 was painless. Dump-restore was quick as hell.
Note that this transition wasn't HA at all :-)
@ivan hmm, is there a nice way of doing major-version upgrades with pgsql with minimal downtime?
@webmind If you had some external replication set up (abstracted from PgSQL data format) I guess it would be. At this time, to my knowledge, replication is one-way street for PgSQL.
@ivan hmm, I do some HA stuff with pgsql, but generally you don't mix major-versions in your replication setup I think.
@webmind that is correct :-) Unless you handle replication outside of postgres (logical repl). Although, this should be possible (or at least better) in PgSQL 10+ and even better with 11.
@webmind Minimal downtime is just to replace it in place and run upgrade. But even minute is unacceptable in some environments.
social.tomica.me is one server in the network