postgres upgrade
I'm trying to upgrade from 8.1 to 8.2.
Apparently the upgrade I just ran through installed a second database
on my server.
I was hoping that the debian configuration would migrate this for me.
I recall there was once a time when it would ask you about moving
data from old to new databases. Is there some way I can do that?
Meanwhile, can I just use pg_dumpall to pull from 8.1 and then reload
into 8.2?
On Sat, May 12, 2007 at 09:36:45AM -0400, Tom Allison wrote:
Meanwhile, can I just use pg_dumpall to pull from 8.1 and then reload
into 8.2?
On Sat, May 12, 2007 at 09:36:45AM -0400, Tom Allison wrote:
I'm trying to upgrade from 8.1 to 8.2.
Apparently the upgrade I just ran through installed a second database
on my server.I was hoping that the debian configuration would migrate this for me.
I recall there was once a time when it would ask you about moving
data from old to new databases. Is there some way I can do that?
Debian has pg_upgradecluster which will migrate from the old version to
the new version. Once migrated you can uninstall 8.1.
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
Show quoted text
From each according to his ability. To each according to his ability to litigate.