I am actually using PostgreSQL 9.1 and I am thinking about upgrading to version 9.4 or 9.5. I have read that the most feasible and secure way to upgrade PostgreSQL to a major version is by using pg_dump/pg_restore. Is this correct?
Does an upgrade applies for going from 32-bit to 64-bit?