Re: Upgrading from 9.1 to 9.3

On Mon, Mar 24, 2014 at 4:21 AM, JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>wrote:

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.

Venkata Balaji N

Sr. Database Administrator
Fujitsu Australia