Re: [ADMIN] postgres 8.2 doesn't start after ubuntu upgrade

2009-03-02 Thread Bryan Keith
>>> How do I install postgres 8.2? I think I installed 8.2 with something >>> like sudo apt-get install postgresql, but that will install 8.3 now, I >>> think. >> >> Try: sudo apt-get install postgresql-8.2 >> >> I'm not sure about Ubuntu. Probably 8.2 isn't included in Intrepid >> anymore. (packa

Re: [ADMIN] postgres 8.2 doesn't start after ubuntu upgrade

2009-03-02 Thread Markus Wanner
Hi, Bryan Keith wrote: > It looks to me like postgresql-8.2 is still available in the hardy > repositories: Yeah, it certainly is in Hardy, but not in Intrepid, as the packages.ubuntu.com website confirmed me now. > Same error. Any suggestions? Did you just forget an "apt-get update" in betwee

Re: [ADMIN] postgres 8.2 doesn't start after ubuntu upgrade

2009-03-02 Thread Bryan Keith
>> How do I install postgres 8.2? I think I installed 8.2 with something >> like sudo apt-get install postgresql, but that will install 8.3 now, I >> think. > > Try: sudo apt-get install postgresql-8.2 > > I'm not sure about Ubuntu. Probably 8.2 isn't included in Intrepid > anymore. (packages.ubun

Re: [ADMIN] postgres 8.2 doesn't start after ubuntu upgrade

2009-03-02 Thread Markus Wanner
Hi, Bryan Keith wrote: > How can I install postgres 8.2 without messing up the data in > /var/lib/postgresql/8.2/main? The way Postgres packages for Debian (and Ubuntu) are built, that's no problem. Just install postgresql-8.2 again. After the upgrade, you can remove the package and the data dire

Re: [ADMIN] postgres 8.2 doesn't start after ubuntu upgrade

2009-03-01 Thread Daniel J. Summers
Bryan Keith wrote: Is the package postgresql-8.2 still installed? I don't know. Maybe not. How can I tell? Try dpkg --list 'postgres*' You'll see several packages - the first column will tell you the status of the package. (There's a key at the top of the output.) -- Daniel J. S

Re: [ADMIN] postgres 8.2 doesn't start after ubuntu upgrade

2009-03-01 Thread Bryan Keith
> > Is the package postgresql-8.2 still installed? I don't know. Maybe not. How can I tell? > Or did the Ubuntu upgrade > automatically deinstall that? What does the log in > /var/log/postgresql/8.2/... say? The last lines of the latest non-empty 8.2 log file are: $ sudo tail -n 15 /var/log/p

Re: [ADMIN] postgres 8.2 doesn't start after ubuntu upgrade

2009-03-01 Thread Markus Wanner
Hi Bryan, Bryan Keith wrote: > After thinking about this a little more, I realize that the problem for me > is not that the upgrade didn't go well. It's that I can't access my data > on 8.2. Well, yeah, if your Postgres 8.2 doesn't even start up, you cannot dump the data from it. And pg_upgradec

Re: [ADMIN] postgres 8.2 doesn't start after ubuntu upgrade

2009-03-01 Thread Bryan Keith
>> On Sat, Feb 28, 2009 at 7:54 PM, Daniel J. Summers >> wrote: >>> >>> The command you're looking for is pg_upgradecluster. There's a >>> description >>> of it at >>> http://manpages.ubuntu.com/manpages/hardy/man8/pg_upgradecluster.8.html >>> . I >>> believe the only time you'll need this is if y

Re: [ADMIN] postgres 8.2 doesn't start after ubuntu upgrade

2009-02-28 Thread Bryan Keith
> On Sat, Feb 28, 2009 at 7:54 PM, Daniel J. Summers > wrote: >> Bryan Keith wrote: >>> >>> I can run 8.3 and see the dbs (the default ones only; not mine) with >>> psql. >>> >> >> I ran into this on an upgrade - however, I didn't do what I'm about to >> describe, and I lost all my data. Luckily,

Re: [ADMIN] postgres 8.2 doesn't start after ubuntu upgrade

2009-02-28 Thread Scott Marlowe
On Sat, Feb 28, 2009 at 7:54 PM, Daniel J. Summers wrote: > Bryan Keith wrote: >> >> I can run 8.3 and see the dbs (the default ones only; not mine) with psql. >> > > I ran into this on an upgrade - however, I didn't do what I'm about to > describe, and I lost all my data. Luckily, it wasn't the o

Re: [ADMIN] postgres 8.2 doesn't start after ubuntu upgrade

2009-02-28 Thread Daniel J. Summers
Bryan Keith wrote: I can run 8.3 and see the dbs (the default ones only; not mine) with psql. I ran into this on an upgrade - however, I didn't do what I'm about to describe, and I lost all my data. Luckily, it wasn't the only place where it was, but there was some development stuff that I h

[ADMIN] postgres 8.2 doesn't start after ubuntu upgrade

2009-02-28 Thread Bryan Keith
Hello, I recently upgraded from Ubuntu 8.04 to 8.10. After the OS upgrade I choose to upgrade software as well (all quite automated in ubuntu). Previously I was running postgres 8.2, but now I have postgres 8.3 (and hopefully 8.2 as well). I can run 8.3 and see the dbs (the default ones only; n