Re: Migration/Upgrade Problems - Mailing list pgsql-general

From David Fetter
Subject Re: Migration/Upgrade Problems
Date
Msg-id 20090417165120.GA10700@fetter.org
Whole thread Raw
In response to Migration/Upgrade Problems  (stevefoss <sfossum@autotraninc.com>)
List pgsql-general
On Fri, Apr 17, 2009 at 09:19:31AM -0700, stevefoss wrote:
>
> I am trying to upgrade my postgresql data from 7.0.3 to 8.3.7 with
> marginal success.  I tried pg_dumpall and got the tables but lost
> most of the data.  I also tried pg_dump but keep getting "FATAL 1:
> Database "whatever" does not exist in the system catalog" errors.  I
> also tried using the latest versions of pg_dump and pg_dumpall but
> they just will not work.  They are looking for some shared library
> file that does not exist.  Any suggestions?  Do I need to upgrade to
> an intermediate version before jumping to the latest version?

As you've intuited, for a version that ancient, you'll probably need
to do this in stages, so

* Get PostgreSQL 7.4.25
* Use its pg_dumpall on the running 7.0.3 database
* Load that into the 7.4.25 database
* Run contrib/adddepend on each of the databases in it
* Use 8.3.7's pg_dumpall to dump the now-fixed 7.4.25 database
* Load that into 8.3.7, and, most importantly,

* Build in and enforce upgrades as part of your maintenance cycle.
  You never want to have to do *anything* like this again.

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

pgsql-general by date:

Previous
From: stevefoss
Date:
Subject: Migration/Upgrade Problems
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Migration/Upgrade Problems