On 05/07/2010 01:22 PM, Alan Hodgson wrote:
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.
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.clark@xxxxxxxxxxxxx
www.netwolves.com
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
