Re: Migration/Upgrade Problems

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(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

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