Search Postgresql Archives

Re: Migration/Upgrade Problems

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxx> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@xxxxxxxxx

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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux