You are reading a single comment by @danb and its replies.
Click here to read the full conversation.
-
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.
danb-
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
An older version than that.
I really need to spend time dragging it up a few versions. In my mind I've kinda thought I'll wait until 10 is released as stable, but I should've been updating it before now.
We're on PostgreSQL 9.2 stable.