Обсуждение: UPGRADE TO V9
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
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
Hi, try to use pg_upgrade - new feature in 9.0
http://www.depesz.com/index.php/2010/05/19/waiting-for-9-0-pg_upgrade/
![](http://s.wisestamp.com/pixel.png?p=chrome&v=2.0.3.0&t=1286783211177&u=2311290&e=8281)
![](http://s.wisestamp.com/pixel.png?p=chrome&v=2.0.3.0&t=1286783211177&u=2311290&e=8281)
2010/10/7 JORGE MALDONADO <jorgemal1960@gmail.com>
I see that I can use pg_dumpall to achieve my purpose.Best regards,Jorge MaldonadoOn 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