Hacker News Reader

Why are you stuck on 9.1? 9.2 was released in september 2012. Upstream support (bug+security fixes) for 9.1 was dropped in november 2016.

I know... The main reason is it is hard to avoid downtime when upgrading older postgres versions (given a large and bussy enough server)

The situation is getting so much better with logical decoding in recent version.

When the upgrade day finally come it will be like christmas with Lateral, Filter, JsonB, Percentile_Disc/Cont, and "upserts"

9.1 => 9.6 is the last supported version to upgrade to. You're going to have to upgrade in 2 steps to get to 10 anyway.