Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group