Re: postgreSQL not working after upgrade to Ubuntu 10.4

On 05/07/2010 01:22 PM, Alan Hodgson wrote:
> 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.
Yes but the install procedure should be smart enough to look and see if you are using a previous
version of Postgres and prompt you if you want to continue installing the
new database.

>
> 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.
>
>

--
Stephen Clark
NetWolves
Sr. Software Engineer III
Phone: 813-579-3200
Fax: 813-882-0209
Email: steve(dot)clark(at)netwolves(dot)com
www.netwolves.com