From: | Venkata Balaji Nagothi <vbnpgc(at)gmail(dot)com> |
---|---|
To: | JORGE MALDONADO <jorgemal1960(at)gmail(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Upgrading from 9.1 to 9.3 |
Date: | 2014-03-23 20:17:09 |
Message-ID: | CAHBAh5tPOiHvECpunGwzuLXKEx_uVAJF+RbHdf71V0Ru=xt8Ew@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | David and Ashley Haycraft | 2014-03-24 23:59:39 | Use of PgOleDB and Microsoft ADODB |
Previous Message | JORGE MALDONADO | 2014-03-23 17:21:25 | Upgrading from 9.1 to 9.3 |