From: | Robert Fitzpatrick <lists(at)webtent(dot)net> |
---|---|
To: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Restoring 8.2 to 8.0 |
Date: | 2007-06-01 22:28:10 |
Message-ID: | 1180736890.20571.9.camel@columbus.webtent.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, 2007-06-01 at 19:24 +0200, RW wrote:
> 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.
Thanks for the idea, but it didn't work. It warned me when trying, I had
to add the -i option to make it dump and I am getting the same ERROR's.
--
Robert
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2007-06-01 22:31:08 | Re: Slightly OT. |
Previous Message | Andrew Sullivan | 2007-06-01 22:25:28 | Re: Slightly OT. |