On Wed, 2011-10-26 at 14:06 +0200, Jean-Yves F. Barbier wrote:
> On Wed, 26 Oct 2011 21:40:03 +1300
> Dagan <mail.list@pro.geek.nz> wrote:
>
> ...
> > Is there a best-practice for upgrading from one version to another?
> > Do I need to manually dump the database from 9.0, and import into 9.1?
>
> Debian supplies a special script for that, read the ... docs.
I found mention on Google about Debian's wrapper scripts, the man page
for pg_upgradecluster isn't so helpful explaining what it's doing.
I ran pg_upgradecluster, it complained the cluster already existed -
the install created a new 9.1 'main' when it installed.
So the process was to do the following:
1) # pg_dropcluster --stop 9.1 main
2) check any applications accessing postgresql are stopped
3) # pg_upgradecluster -v 9.1 9.0 main
Then check my applications worked accessing the database, which they
did.
cheers,
Dagan