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?
