On Friday 07 May 2010, AllieH <allison.hoch@xxxxxxxxxx> wrote: > Yesterday I upgraded from Ubuntu 9.10 to 10.4. Unfortunately this has > caused me serious problems with everything related to postgreSQL. It > seems as though the new version of ubuntu is requiring me to use > PostgreSQL 8.4 instead of 8.3 which I was previously using. I tried > installing 8.4 but I can't seem to get the database to start. Has anyone > had a similar problems? > Major OS version upgrades don't transparently do database upgrades. You have to take care of things like that yourself. In particular, for PostgreSQL, you would need to dump all your databases using 8.3, then upgrade, then create a new 8.4 installation and restore the databases into it. Sadly PostgreSQL does not do in-place major version upgrades. In your case, you need to stop and make a couple good filesystem-level backups of your database. Then you need to find a way to either get 8.3 working on that machine, or move the database to another machine where you can get it working, so you can do the PostgreSQL backup. Then you can think about getting 8.4 setup on your upgraded machine and restore that backup into it. You should probably also read through the 8.4 release notes to see if you will require changes in any applications using those databases. -- "No animals were harmed in the recording of this episode. We tried but that damn monkey was just too fast." -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
