Re: UPGRADE TO V9

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