Restoring 8.2 to 8.0

From: Robert Fitzpatrick <lists(at)webtent(dot)net>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Restoring 8.2 to 8.0
Date: 2007-06-01 16:02:20
Message-ID: 1180713740.4982.8.camel@columbus.webtent.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

--
Robert

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Csaba Nagy 2007-06-01 16:08:58 Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum
Previous Message Alvaro Herrera 2007-06-01 15:54:05 Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum