Re: postgreSQL not working after upgrade to Ubuntu 10.4

On Friday 07 May 2010, AllieH <allison(dot)hoch(at)ll(dot)mit(dot)edu> 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."