You are reading a single comment by @Velocio and its replies.
Click here to read the full conversation.
-
I've actually increased my backup frequency and dropped the slave, in readiness of an upgrade.
We're operating well within the capabilities of a single server with lots of headroom, and I figure once on 10 I can add replication back based on the newer features.
I'm kinda glad this approach is even an option... the work version is on 9.6 but holy moly that was a pain to upgrade to.
Velocio
I feel your pain, we have a few (big,replicated) legacy systems on 9.2 that need upgrading. pg_upgrade helps (and is quick if using hard links), but only for the master - slaves still need data to be rsync'ed.
PG10 does look very cool, logical replication and better control over the planner especially.