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


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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Hi, try to use pg_upgrade - new feature in 9.0

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-2017 The PostgreSQL Global Development Group