[Bug 403381] Re: jaunty->karmic server upgrade results in two versions of postgresql installed

[Dmole]

On the missing 8.3 install instructions:
(untested for now)

DUMP=/my/dump/path
MYDB=preciousdata 
pg_ctlcluster 8.4 main stop
pg_dropcluster 8.4 main
echo -e "\ndeb http://security.ubuntu.com/ubuntu hardy-security main restricted\ndeb-src http://security.ubuntu.com/ubuntu hardy-security main restricted\n">>/etc/apt/sources.list
apt-get update
apt-get install -y postgresql-8.3
#not needed
    #pg_ctlcluster 8.3 main start
# extra backup
    cp -r /var/lib/postgresql/8.3/main $DUMP/copy
    su postgres -c "pg_dumpall -f $DUMP/$MYDB.dump -l $MYDB -U postgres"
pg_upgradecluster -v 8.4 8.3 main
pg_ctlcluster 8.3 main stop
pg_dropcluster 8.3 main
pg_ctlcluster 8.4 main start
apt-get remove -y postgresql-8.3


Thanks to Flannel on irc://chat.freenode.net/#ubuntu

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to bacula in Ubuntu.
https://bugs.launchpad.net/bugs/403381

Title:
  jaunty->karmic server upgrade results in two versions of postgresql
  installed