I´ve dumped a Database from an old Ubuntu machine with postgresql 8.4 wiandth postgis 1.5. On a new ubuntu 12.04 I´ve installed Postgresql 9.1 also with postgis 1.5. (created the postgis_template with postgis.sql and spatial_ref_sys.sql).
When I restore the dump on the new machine, the data is build but I get 25 Error Messages like these
...
pg_restore: [archiver (db)] Error from TOC entry 711; 1255 18533 FUNCTION gidx_in(cstring) postgres
pg_restore: [archiver (db)] could not execute query: ERROR: function public.gidx_in(cstring) does not exist
Command was: DROP FUNCTION public.gidx_in(cstring);
pg_restore: [archiver (db)] Error from TOC entry 34; 1255 17743 FUNCTION geometry_send(geometry) postgres
pg_restore: [archiver (db)] could not execute query: ERROR: type "geometry" does not exist
Command was: DROP FUNCTION public.geometry_send(geometry);
pg_restore: [archiver (db)] Error from TOC entry 33; 1255 17742 FUNCTION geometry_recv(internal) postgres
pg_restore: [archiver (db)] could not execute query: ERROR: function public.geometry_recv(internal) does not exist
Command was: DROP FUNCTION public.geometry_recv(internal);
pg_restore: [archiver (db)] Error from TOC entry 31; 1255 17740 FUNCTION geometry_out(geometry) postgres
pg_restore: [archiver (db)] could not execute query: ERROR: type "geometry" does not exist
Command was: DROP FUNCTION public.geometry_out(geometry);
pg_restore: [archiver (db)] Error from TOC entry 30; 1255 17739 FUNCTION geometry_in(cstring) postgres
pg_restore: [archiver (db)] could not execute query: ERROR: function public.geometry_in(cstring) does not exist
Command was: DROP FUNCTION public.geometry_in(cstring);
pg_restore: [archiver (db)] Error from TOC entry 709; 1255 18529 FUNCTION geography_out(geography) postgres
pg_restore: [archiver (db)] could not execute query: ERROR: type "geography" does not exist
Command was: DROP FUNCTION public.geography_out(geography);
Can Anyone explain whats going on? And can I ignore those Errors?
Thanks! With kind regards,
Toni