| From: | Krzysztof Hoffmann <krzysiekpl(at)gmail(dot)com> |
|---|---|
| To: | JORGE MALDONADO <jorgemal1960(at)gmail(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: UPGRADE TO V9 |
| Date: | 2010-10-11 07:47:54 |
| Message-ID: | AANLkTinMPE+kv=L1-rDor0jCV2zZzCwj4y2OunroZZGP@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hi, try to use pg_upgrade - new feature in 9.0
http://www.depesz.com/index.php/2010/05/19/waiting-for-9-0-pg_upgrade/
2010/10/7 JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
> I see that I can use pg_dumpall to achieve my purpose.
>
> Best regards,
> Jorge Maldonado
>
> On Thu, Oct 7, 2010 at 11:58 AM, JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>wrote:
>
>> I am actually using PostgreSQL v8.4 and want to upgrade to v9. I have
>> several login roles with privileges assigned to the different databases.
>> What happens to such login roles? How do I take them to the new
>> installation?
>> Also, what about the tablespaces?
>> How do I take everything in my actual installation to the new one?
>>
>> Respectfully,
>> Jorge Maldonado
>>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-10-11 13:47:30 | Re: Creating index on different tablespace and its temp files |
| Previous Message | Marcin Mirosław | 2010-10-11 07:47:31 | Creating index on different tablespace and its temp files |