Current version:

PostgreSQL 9.4.9 on x86_64-unknown-linux-gnu, compiled by gcc (Debian 4.9.2-10) 4.9.2, 64-bit


Debian GNU/Linux 8.6 (jessie)

Any considerations and/or recommendations on upgrading to 9.6.x? I've read a few questions suggesting replication to the higher version while, others suggest using pg_upgrade.

  • 2
    (Streaming) replication is not supposed to work between major versions. Use pg_upgrade, it is the officially documented way. Unless you can afford downtime - in which case setting up the new version and dump/restore is also a possibility. – dezso Oct 4 '17 at 14:57
  • The only replication option right now for 9.4 to 9.6 would be slony. Otherwise pg_upgrade or dump and restore are the way to go. – Scott Marlowe Oct 9 '17 at 20:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.