Re: [GENERAL] Migration/Upgrade Problems

2009-04-17 Thread Tom Lane
"Joshua D. Drake" writes: > Your library problems are likely because you just copied the binary? I > assume you didn't actually install postgresql. That's what it looked like to me --- you can't just copy an executable that's been built on a far newer platform. However, you could run pg_dumpall

Re: [GENERAL] Migration/Upgrade Problems

2009-04-17 Thread Alvaro Herrera
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. No i

Re: [GENERAL] Migration/Upgrade Problems

2009-04-17 Thread Joshua D. Drake
On Fri, 17 Apr 2009 09:19:31 -0700 (PDT), 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 >

Re: [GENERAL] Migration/Upgrade Problems

2009-04-17 Thread David Fetter
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

[GENERAL] Migration/Upgrade Problems

2009-04-17 Thread stevefoss
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 v