Robert Fitzpatrick <lists@xxxxxxxxxxx> writes: > I have a dump from 8.2 restored to file that was pg_dump'd with format c > from a production server. I want to know if it is possible for me to > restore this to a 8.0 development server where I am not able to upgrade > at this time. I don't think you'll have much alternative but to manually edit the dump file. If I were you I'd dump the schema as text, hack it until it loads, then do a data-only dump in Fc or whatever format you want. FWIW the specific errors you're mentioning have to do with SERIAL columns, so if that's all you're seeing then it should be a pretty simple set of edits. You might want to divvy up the schema into stuff to apply before the data load and stuff to apply after --- indexes and foreign keys go in the latter set. See the performance tips about "populating a database". regards, tom lane
