Thread: Debian upgrade from 9.0 to 9.1?
Hi all, I notice that Postgresql 9.1 is available in the backports for Debian Squeeze. I note that it installed side-by-side with version 9.0, which I already have running a small database. 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? Cheers, Dagan
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. -- May you do Good Magic with Perl. -- Larry Wall's blessing
On Wed, Oct 26, 2011 at 4:40 AM, Dagan <mail.list@pro.geek.nz> wrote:
Hi all,
I notice that Postgresql 9.1 is available in the backports for Debian
Squeeze. I note that it installed side-by-side with version 9.0, which I
already have running a small database.
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?
Cheers,
Dagan
On Wed, 2011-10-26 at 09:00 -0400, Henry Drexler wrote: > > > On Wed, Oct 26, 2011 at 4:40 AM, Dagan <mail.list@pro.geek.nz> wrote: > Hi all, > > I notice that Postgresql 9.1 is available in the backports > for Debian > Squeeze. I note that it installed side-by-side with version > 9.0, which I > already have running a small database. > > 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? > > Cheers, > Dagan > http://www.postgresql.org/docs/current/static/pgupgrade.html I found Debian provides it's own set of wrapper scripts, in this case pg_upgradecluster Dagan
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