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 -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs