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
>> Also, what about the tablespaces?
>> How do I take everything in my actual installation to the new one?
>> Jorge Maldonado
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2010-10-11 13:47:30|
|Subject: Re: Creating index on different tablespace and its temp files |
|Previous:||From: Marcin Mirosław||Date: 2010-10-11 07:47:31|
|Subject: Creating index on different tablespace and its temp files|