[Bug 403381] Re: jaunty-karmic server upgrade results in two versions of postgresql installed
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
[Bug 403381] Re: jaunty-karmic server upgrade results in two versions of postgresql installed
** Tags added: iso-testing -- jaunty-karmic server upgrade results in two versions of postgresql installed https://bugs.launchpad.net/bugs/403381 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to bacula in ubuntu. -- 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
[Bug 403381] Re: jaunty-karmic server upgrade results in two versions of postgresql installed
Nevermind.. I didn't pay enough attention to what the message was telling me. 8.3 really *was* uninstalled; I had seen 8.3 files floating around my system and assumed it was still installed. So I reinstalled it and then all worked as it should. Don't I feel dumb... -- jaunty-karmic server upgrade results in two versions of postgresql installed https://bugs.launchpad.net/bugs/403381 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to bacula in ubuntu. -- 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
[Bug 403381] Re: jaunty-karmic server upgrade results in two versions of postgresql installed
That list of instructions leaves out how to get 8.3 to start. On my just-upgraded karmic, 8.3 won't run any more. (8.4 runs but I can't log into it, for that matter) r...@merrithewi-desktop:init.d# pg_ctlcluster 8.3 main start Error: pg_controldata not found, please install postgresql-8.3 I admit I don't know much about postgresql; I was only using it as amarok 1.4's backend. I'd like to either upgrade that database from 8.3 to 8.4 or get 8.3 to run. I assumed the upgrade would leave things in a working state, wrongly as it turned out. -- jaunty-karmic server upgrade results in two versions of postgresql installed https://bugs.launchpad.net/bugs/403381 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to bacula in ubuntu. -- 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
[Bug 403381] Re: jaunty-karmic server upgrade results in two versions of postgresql installed
Just to help some people out who ended up in this situation (if you ignored the debconf message): I found a nice little example on how to repair this on http://www.tumblr.com/tagged/server+administration . 1. Stop cluster for 8.4, if it’s running: sudo pg_ctlcluster 8.4 main stop 2. Drop the cluster for 8.4 sudo pg_dropcluster 8.4 main 3. With 8.3 running, run pg_upgradecluster sudo pg_upgradecluster -v 8.4 8.3 main 4. If all goes well, cluster for 8.3 can be dropped sudo pg_dropcluster 8.3 main And we are probably back on track with PostgreSQL. -- jaunty-karmic server upgrade results in two versions of postgresql installed https://bugs.launchpad.net/bugs/403381 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to bacula in ubuntu. -- 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
[Bug 403381] Re: jaunty-karmic server upgrade results in two versions of postgresql installed
bacula is the only package in main which directly depends on 8.3, will fix. ** Also affects: bacula (Ubuntu) Importance: Undecided Status: New ** Changed in: bacula (Ubuntu) Importance: Undecided = High ** Changed in: bacula (Ubuntu) Status: New = In Progress ** Changed in: bacula (Ubuntu) Assignee: (unassigned) = Martin Pitt (pitti) -- jaunty-karmic server upgrade results in two versions of postgresql installed https://bugs.launchpad.net/bugs/403381 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to bacula in ubuntu. -- 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
[Bug 403381] Re: jaunty-karmic server upgrade results in two versions of postgresql installed
postgresql-8.3 demoted to universe now. So with the p-common fix, you will get a debconf explanation on upgrade which explains how to transition your 8.3 clusters to 8.4 (just as with all previous Ubuntu releases). -- jaunty-karmic server upgrade results in two versions of postgresql installed https://bugs.launchpad.net/bugs/403381 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to bacula in ubuntu. -- 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
[Bug 403381] Re: jaunty-karmic server upgrade results in two versions of postgresql installed
This bug was fixed in the package bacula - 2.4.4-1ubuntu6 --- bacula (2.4.4-1ubuntu6) karmic; urgency=low * debian/control: Change build and binary dependencies to PostgreSQL 8.4. (LP: #403381) -- Martin Pitt martin.p...@ubuntu.com Thu, 23 Jul 2009 11:53:12 +0200 ** Changed in: bacula (Ubuntu) Status: In Progress = Fix Released -- jaunty-karmic server upgrade results in two versions of postgresql installed https://bugs.launchpad.net/bugs/403381 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to bacula in ubuntu. -- 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
[Bug 403381] Re: jaunty-karmic server upgrade results in two versions of postgresql installed
postgresql-8.3 demoted to universe. ** Changed in: postgresql-8.3 (Ubuntu) Status: In Progress = Fix Released -- jaunty-karmic server upgrade results in two versions of postgresql installed https://bugs.launchpad.net/bugs/403381 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to bacula in ubuntu. -- 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