I've never tried this but maybe it works if you use pg_dump from 8.0 to do the dump. Greetings Robert Robert Fitzpatrick wrote:
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. Trying to do some testing, but this is the only other server that's available right now. I tried a normal restore and start getting errors relating to regclass: honeypot:~ # psql -U postgres trax < pgtrax.sql <snip> ERROR: cannot cast type text to regclass ERROR: relation "public.tblmenu" does not exist ERROR: function nextval(regclass) does not exist Is there a way I can prepare my dump to work? There is a lot of data, so I need to maintain COPY methods of inserting.
