Have you tried dumping the database in 2 steps?
First, dump the database schema only. Review and edit
the SQL manually. Then dump the database data only.
Once you can recreate the database structure without
problems, you can copy the data into the tables.
I hope I haven't oversimplified the issue.
Best of luck,
Andrew Gould
--- Raymond Curtis Rodgers <rcrodgers@eudoramail.com>
wrote:
> I find myself in an odd position. Some how, over the
> last few months, I ended up with a 7.2 [development]
> installation where once I had a 7.1.3 installation.
> Now that I'm in the process of trying to migrate the
> data to another 7.1.3 installation, I appear to be
> stuck as pg_dump and pg_dumpall aren't working out
> for me. I get lots of errors on import as you might
> well imagine.
>
> Does anyone have any suggestions on how to correct
> this situation, or at least retrieve the data,
> tables, etc., without having to manually recreate it
> all?
>
> Thanks,
> Raymond
>
>
> Join 18 million Eudora users by signing up for a
> free Eudora Web-Mail account at
> http://www.eudoramail.com
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please
> send an appropriate
> subscribe-nomail command to majordomo@postgresql.org
> so that your
> message can get through to the mailing list cleanly
__________________________________________________
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com