I am planning to upgrade PostgreSQL from version 9.1 to 9.3 and I would like to do it backing up the current 9.1 DB with 9.3 backup command. My actual DB has a tablespace, group roles and login roles. I suppose that I need to "re-create" the whole picture including the tablespace, group roles and login roles. So, after backing up my DB, I should delete the tablespace in order to create it in the new version. Also, I should add the group and login roles to the new version and finally perform a restore. Of course, the backup should contain table privilegies. Is my approach correct or is there an easier way to achieve my goal?
The best and easiest way to achieve this is by performing a pg_upgrade. Not sure if you have considered this option.
Please let us know if you need further help on pg_upgrade.
