[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

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 exist

Re: [GENERAL] Migration/Upgrade Problems

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

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

Re: [GENERAL] Migration/Upgrade Problems

2009-04-17 Thread Tom Lane
Joshua D. Drake j...@commandprompt.com 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