> > 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 > -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
