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