Re: postgres 8.2 doesn't start after ubuntu upgrade

>
> 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/postgresql/postgresql-8.2-main.log.1
2009-02-24 14:01:51 MST LOG: shutting down
2009-02-24 14:01:51 MST LOG: database system is shut down
2009-02-24 14:01:52 MST LOG: could not load root certificate file
"root.crt": no SSL error reported
2009-02-24 14:01:52 MST DETAIL: Will not verify client certificates.
2009-02-24 14:01:52 MST LOG: database system was shut down at 2009-02-24
14:01:51 MST
2009-02-24 14:01:52 MST LOG: checkpoint record is at 0/3222C388
2009-02-24 14:01:52 MST LOG: redo record is at 0/3222C388; undo record is
at 0/0; shutdown TRUE
2009-02-24 14:01:52 MST LOG: next transaction ID: 0/2559565; next OID: 29907
2009-02-24 14:01:52 MST LOG: next MultiXactId: 1; next MultiXactOffset: 0
2009-02-24 14:01:52 MST LOG: database system is ready
2009-02-24 14:01:52 MST LOG: incomplete startup packet
2009-02-24 14:35:59 MST LOG: incomplete startup packet
2009-02-24 14:35:59 MST LOG: received fast shutdown request
2009-02-24 14:35:59 MST LOG: shutting down
2009-02-24 14:35:59 MST LOG: database system is shut down
$

The last entries in the log file are from the day of the upgrade. So I'm
guessing postgres 8.2 isn't installed. I guess now the questions are:

How can I install postgres 8.2 without messing up the data in
/var/lib/postgresql/8.2/main?

Can I just copy that to a new location and copy it back after the
installation? Or...?

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.

Thank you everyone for the help.

Bryan

>
> Regards
>
> Markus Wanner
>