[Pkg-postgresql-public] Re: oldstable to stable upgrades

[Michelle Konzack]

Hello Martin,

Am 2007-04-17 08:45:20, schrieb Martin Pitt:
> 7.5 is a 'fake' version. Etch's 'postgresql' is a transitional package
> that has some bits to move Sarge's data of postgresql into the new
> multiversion/multicluster architecture of Etch's postgresql-<version>
> packages. Thus after the upgrade you will have postgresql-7.4
> installed, just as in Sarge, so that the actual db data will not be
> touched during the upgrade. 

This gaved me a realy mixed feeling...  :-/

> You can later install postgresql-8.1 and conveniently migrate the 7.4
> data to 8.1 with pg_upgradecluster (see its manpage), test the 8.1
> cluster, and have the security of having your original 7.4 instance as
> a rollback.

Since i have gotten a bunch of 1 TByte Hitachi drives it was possibel
to run both parallel.  I had concerns, since my PostgreSQL consumes
currently 680 GByte of diskspace and it is not easy to dump this
ammount of Data arround...

> > I was planning to try an upgrade in a chroot and see how that worked -
> > is that excessive?
> 
> If you have a fairly standard Sarge setup (data in
> /var/lib/postgresql, no symlink hacks, etc.) it should work smoothly

Yeah.. I have had problems with this, since I have put my 6 PostgreSQL
homes into /home/postgres-<flav>  because I run 6 PostgreSQL Servers
on 6 different ports.

Only the first ${HOME} was reconized right.

> (I had an automated test for that), but of course testing it before
> can never hurt. The Sarge->Etch update still has potential for
> breakage, with the new architecture in Etch upgrades will be much
> safer in the future.

I home, since Etch is NOW THE IRST RELEASE which has broken my network.
(Upgraded from Slink to Potato, Woody and Sarge and beginning with
PostgreSQL 6.something)

Greetings
    Michelle Konzack
    Systemadministrator
    Tamay Dogan Network
    Debian GNU/Linux Consultant


-- 
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack   Apt. 917                  ICQ #328449886
                   50, rue de Soultz         MSN LinuxMichi
0033/6/61925193    67100 Strasbourg/France   IRC #Debian (irc.icq.com)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://lists.alioth.debian.org/pipermail/pkg-postgresql-public/attachments/20070424/296de569/attachment.pgp