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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse sfpug by date

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