Hello,
Our PG runs on Ubuntu boxes and it’s 9.3.4, thinking of upgrading to 9.3.12 or 9.5.2.
Is the normal approach of upgrade something like below, no matter if it’s major version or minor version upgrade? My focus is on pg_dump at the moment.
#1 pg_dump
Dump DB
Apt-get update
Apt-get install new version
Createdb
Import DB
#2 pg_upgrade (a little complicated, worth trying on test environment)
#3 using trigger based replication tool (not interested at this moment)
Thanks,
Suya