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

pg_dump/pg_restore in 8.0.3 dependency checking?

From: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
To: SF Postgres <sfpug(at)postgresql(dot)org>
Subject: pg_dump/pg_restore in 8.0.3 dependency checking?
Date: 2005-05-21 00:58:45
Message-ID: Pine.LNX.4.62.0505201756130.26887@discord.dyndns.org (view raw or flat)
Thread:
Lists: sfpug
Hi guys,

I thought that 8.0.x's pg_dump/restore was going to have much better object 
dependency checking?  I just did a test dump/restore between our new 8.0.3 
system and a test 8.0.3 system and received the following output from 
pg_restore:

pg_restore: [archiver (db)] could not execute query: ERROR:  function 
convert_decimalto_degrees(numeric) does not exist
HINT:  No function matches the given name and argument types. You may need to 
add explicit type casts.
     Command was: CREATE VIEW vw_place_dms AS
     SELECT place.place_id, place.type_id, place.name, place.name_qualified, 
place.name_local, pl...
pg_restore: [archiver (db)] could not execute query: ERROR:  relation 
"public.vw_place_dms" does not exist
     Command was: ALTER TABLE public.vw_place_dms OWNER TO postgres;
pg_restore: [archiver (db)] Error from TOC entry 3083; 0 0 SEQUENCE SET 
x_place_directory_place_directory_id_seq postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  function 
pg_catalog.pg_get_serial_sequence("unknown", "unknown") does not exist
HINT:  No function matches the given name and argument types. You may need to 
add explicit type casts.
     Command was: SELECT 
pg_catalog.setval(pg_catalog.pg_get_serial_sequence('x_place_directory', 
'place_directory_id'), 7233010, true);

The specific commands were:

pg_dump --format=c -f /tmp/vbtest.dmp vbtest

pg_restore  -d vbtest /tmp/vbtest.dmp

Should I have used some other options to pg_dump or pg_restore that I'm not 
aware of?

-- 
Jeff Frost, Owner 	<jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954

Responses

sfpug by date

Next:From: Josh BerkusDate: 2005-05-21 02:35:07
Subject: Re: pg_dump/pg_restore in 8.0.3 dependency checking?
Previous:From: Josh BerkusDate: 2005-05-20 19:50:34
Subject: Re: reservation overlap constraint checking?

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