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
>