Postgres Pro
Downloads
Home   >   mailing lists

Re: UPGRADE TO V9 - Mailing list pgsql-novice

From JORGE MALDONADO
Subject Re: UPGRADE TO V9
Date
Msg-id AANLkTik7y3ZszmySMYpiVA8kVcwcaxPg6XZg9vKAPNxP@mail.gmail.com
Whole thread Raw
In response to UPGRADE TO V9  (JORGE MALDONADO <jorgemal1960@gmail.com>)
Responses Re: UPGRADE TO V9  (Krzysztof Hoffmann <krzysiekpl@gmail.com>)
List pgsql-novice
Tree view
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@gmail.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

pgsql-novice by date:

Previous
From: JORGE MALDONADO
Date:
Subject: UPGRADE TO V9
Next
From: Arvind Sharma
Date:
Subject: Scheduling a Stored Procedure?