restoring db from 8.1 in a 8.0 db

From: sten govaerts <sten(dot)govaerts(at)cs(dot)kuleuven(dot)ac(dot)be>
To: pgsql-novice(at)postgresql(dot)org
Subject: restoring db from 8.1 in a 8.0 db
Date: 2006-03-10 09:26:13
Message-ID: 5F50B584-6125-4584-933A-DE5EF378CD2D@cs.kuleuven.ac.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,

I have different database installations. One is a postgresql 8.0 and
one is a 8.1 installation.

I want to move the database from postgres 8.1 to the postgres 8.0
installation. When i restore the dump i created in 8.1, there are
more then 50 errors. thre seems to be a problem with the sequences. I
checked the postgresql documentation and i noticed that in 8.0 the
function nextval takes a text-type and in 8.1 a regclass-type.

How can i get a dump of the 8.1 db that works on the 8.0 install?

Here is a dump of the errors:

pg_restore: creating TABLE actuality
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 1245; 1259 798837
TABLE actuality postgres
pg_restore: [archiver (db)] could not execute query: ERROR: cannot
cast type text to regclass
Command was: CREATE TABLE actuality (
gid integer DEFAULT nextval(('public.gid_seq'::text)::regclass)
NOT NULL,
actualityname cha...
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"public.actuality" does not exist
Command was: ALTER TABLE public.actuality OWNER TO postgres;
pg_restore: creating TABLE albums
pg_restore: executing SEQUENCE SET albums_album_id_seq
pg_restore: creating TABLE altgroupname
pg_restore: executing SEQUENCE SET altgroupname_altgrp_id_seq
pg_restore: creating TABLE artists
pg_restore: executing SEQUENCE SET artists_artist_id_seq
pg_restore: creating TABLE continents
pg_restore: [archiver (db)] Error from TOC entry 1252; 1259 798855
TABLE continents postgres
pg_restore: [archiver (db)] could not execute query: ERROR: cannot
cast type text to regclass
Command was: CREATE TABLE continents (
gid integer DEFAULT nextval(('gid_seq'::text)::regclass) NOT NULL,
continentname character...
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"public.continents" does not exist
Command was: ALTER TABLE public.continents OWNER TO postgres;
pg_restore: creating TABLE dancability
pg_restore: [archiver (db)] Error from TOC entry 1253; 1259 798858
TABLE dancability postgres
pg_restore: [archiver (db)] could not execute query: ERROR: cannot
cast type text to regclass
Command was: CREATE TABLE dancability (
gid integer DEFAULT nextval(('public.gid_seq'::text)::regclass)
NOT NULL,
dancabilityname...
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"public.dancability" does not exist
Command was: ALTER TABLE public.dancability OWNER TO postgres;
pg_restore: creating TABLE dancestyles
pg_restore: [archiver (db)] Error from TOC entry 1254; 1259 798861
TABLE dancestyles postgres
pg_restore: [archiver (db)] could not execute query: ERROR: cannot
cast type text to regclass
Command was: CREATE TABLE dancestyles (
gid integer DEFAULT nextval(('gid_seq'::text)::regclass) NOT NULL,
dancestylename charact...
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"public.dancestyles" does not exist
Command was: ALTER TABLE public.dancestyles OWNER TO postgres;
pg_restore: creating TABLE filmtv
pg_restore: executing SEQUENCE SET filmtv_filmtv_id_seq
pg_restore: creating TABLE generalvalue
pg_restore: [archiver (db)] Error from TOC entry 1257; 1259 798869
TABLE generalvalue postgres
pg_restore: [archiver (db)] could not execute query: ERROR: cannot
cast type text to regclass
Command was: CREATE TABLE generalvalue (
gid integer DEFAULT nextval(('public.gid_seq'::text)::regclass)
NOT NULL
);
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"public.generalvalue" does not exist
Command was: ALTER TABLE public.generalvalue OWNER TO postgres;
pg_restore: creating TABLE genres
pg_restore: [archiver (db)] Error from TOC entry 1258; 1259 798872
TABLE genres postgres
pg_restore: [archiver (db)] could not execute query: ERROR: cannot
cast type text to regclass
Command was: CREATE TABLE genres (
gid integer DEFAULT nextval(('gid_seq'::text)::regclass) NOT NULL,
genrename character varying...
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"public.genres" does not exist
Command was: ALTER TABLE public.genres OWNER TO postgres;
pg_restore: creating SEQUENCE gid_seq
pg_restore: executing SEQUENCE SET gid_seq
pg_restore: creating TABLE groupartist
pg_restore: creating TABLE groups
pg_restore: executing SEQUENCE SET groups_group_id_seq
pg_restore: creating TABLE loudness
pg_restore: [archiver (db)] Error from TOC entry 1263; 1259 798884
TABLE loudness postgres
pg_restore: [archiver (db)] could not execute query: ERROR: cannot
cast type text to regclass
Command was: CREATE TABLE loudness (
gid integer DEFAULT nextval(('public.gid_seq'::text)::regclass)
NOT NULL,
loudnessname chara...
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"public.loudness" does not exist
Command was: ALTER TABLE public.loudness OWNER TO postgres;
pg_restore: creating TABLE parameters
pg_restore: executing SEQUENCE SET parameters_param_id_seq
pg_restore: creating TABLE partylevels
pg_restore: [archiver (db)] Error from TOC entry 1266; 1259 798892
TABLE partylevels postgres
pg_restore: [archiver (db)] could not execute query: ERROR: cannot
cast type text to regclass
Command was: CREATE TABLE partylevels (
gid integer DEFAULT nextval(('public.gid_seq'::text)::regclass)
NOT NULL,
partylevelname ...
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"public.partylevels" does not exist
Command was: ALTER TABLE public.partylevels OWNER TO postgres;
pg_restore: creating TABLE popularity
pg_restore: [archiver (db)] Error from TOC entry 1267; 1259 798895
TABLE popularity postgres
pg_restore: [archiver (db)] could not execute query: ERROR: cannot
cast type text to regclass
Command was: CREATE TABLE popularity (
gid integer DEFAULT nextval(('public.gid_seq'::text)::regclass)
NOT NULL,
popname characte...
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"public.popularity" does not exist
Command was: ALTER TABLE public.popularity OWNER TO postgres;
pg_restore: creating TABLE recordlabels
pg_restore: executing SEQUENCE SET recordlabels_recordlbl_id_seq
pg_restore: creating TABLE rhythmstyles
pg_restore: [archiver (db)] Error from TOC entry 1270; 1259 798903
TABLE rhythmstyles postgres
pg_restore: [archiver (db)] could not execute query: ERROR: cannot
cast type text to regclass
Command was: CREATE TABLE rhythmstyles (
gid integer DEFAULT nextval(('public.gid_seq'::text)::regclass)
NOT NULL,
rhythmname cha...
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"public.rhythmstyles" does not exist
Command was: ALTER TABLE public.rhythmstyles OWNER TO postgres;
pg_restore: creating TABLE songs
pg_restore: creating VIEW searchsongs
pg_restore: [archiver (db)] Error from TOC entry 1273; 1259 798934
VIEW searchsongs postgres
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"genres" does not exist
Command was: CREATE VIEW searchsongs AS
SELECT songs.song_id, songs.title, songs."year", songs.version,
songs.lyrics, songs.isrc, son...
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"public.searchsongs" does not exist
Command was: ALTER TABLE public.searchsongs OWNER TO postgres;
pg_restore: executing SEQUENCE SET songs_song_id_seq
pg_restore: creating TABLE songvalue
pg_restore: creating TABLE subgenres
pg_restore: [archiver (db)] Error from TOC entry 1275; 1259 798940
TABLE subgenres postgres
pg_restore: [archiver (db)] could not execute query: ERROR: cannot
cast type text to regclass
Command was: CREATE TABLE subgenres (
gid integer DEFAULT nextval(('gid_seq'::text)::regclass) NOT NULL,
subgenrename character v...
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"public.subgenres" does not exist
Command was: ALTER TABLE public.subgenres OWNER TO postgres;
pg_restore: creating TABLE types
pg_restore: [archiver (db)] Error from TOC entry 1276; 1259 798943
TABLE types postgres
pg_restore: [archiver (db)] could not execute query: ERROR: cannot
cast type text to regclass
Command was: CREATE TABLE types (
gid integer DEFAULT nextval(('gid_seq'::text)::regclass) NOT NULL,
typename character varying(5...
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"public.types" does not exist
Command was: ALTER TABLE public.types OWNER TO postgres;
pg_restore: creating TABLE valuedepends
pg_restore: creating TABLE values
pg_restore: [archiver (db)] Error from TOC entry 1278; 1259 798948
TABLE values postgres
pg_restore: [archiver (db)] could not execute query: ERROR: cannot
cast type text to regclass
Command was: CREATE TABLE "values" (
gid integer DEFAULT nextval(('public.gid_seq'::text)::regclass)
NOT NULL,
valuename characte...
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"public.values" does not exist
Command was: ALTER TABLE public."values" OWNER TO postgres;
pg_restore: creating TABLE voices
pg_restore: [archiver (db)] Error from TOC entry 1279; 1259 798951
TABLE voices postgres
pg_restore: [archiver (db)] could not execute query: ERROR: cannot
cast type text to regclass
Command was: CREATE TABLE voices (
gid integer DEFAULT nextval(('public.gid_seq'::text)::regclass)
NOT NULL,
voice character vary...
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"public.voices" does not exist
Command was: ALTER TABLE public.voices OWNER TO postgres;

Thank you,

Sten

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2006-03-10 15:27:58 Re: restoring db from 8.1 in a 8.0 db
Previous Message Christoph Della Valle 2006-03-10 06:51:12 Re: Function to convert numeric string to number in version