|
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 |
