Skip site navigation (1) Skip section navigation (2)

Re: UPGRADE TO V9

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 (view raw or flat)
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
>>
>
>

In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2010-10-11 13:47:30
Subject: Re: Creating index on different tablespace and its temp files
Previous:From: Marcin MirosławDate: 2010-10-11 07:47:31
Subject: Creating index on different tablespace and its temp files

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group