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 <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general