dbb@test-32:/home/shared/srcs_test32/postgis_trunk$ utils/postgis_restore.pl /home/shared/vmt_test.dump | psql vmt_test Converting /home/shared/vmt_test.dump to ASCII on stdout... Reading list of functions to ignore... Writing manifest of things to read from dump file... Writing ASCII to stdout... ALTER TABLE SET SET SET SET SET CREATE EXTENSION COMMENT SET ERROR: could not access file "$libdir/postgis-1.5": No such file or directory ERROR: function public._st_asgml(integer, geometry, integer, integer) does not exist ERROR: could not access file "$libdir/postgis-1.5": No such file or directory ERROR: function public._st_asgml(integer, geography, integer, integer) does not exist ERROR: could not access file "$libdir/postgis-1.5": No such file or directory ERROR: function public._st_askml(integer, geography, integer) does not exist ERROR: could not access file "$libdir/postgis-1.5": No such file or directory ERROR: function public.geography_gist_consistent(internal, geometry, integer) does not exist ERROR: could not access file "$libdir/postgis-1.5": No such file or directory ERROR: function public.geography_typmod_dims(integer) does not exist ERROR: could not access file "$libdir/postgis-1.5": No such file or directory ERROR: function public.geography_typmod_srid(integer) does not exist ERROR: could not access file "$libdir/postgis-1.5": No such file or directory ERROR: function public.geography_typmod_type(integer) does not exist ERROR: could not access file "$libdir/postgis-1.5": No such file or directory ERROR: function public.geometry_gist_joinsel(internal, oid, internal, smallint) does not exist ERROR: could not access file "$libdir/postgis-1.5": No such file or directory ERROR: function public.geometry_gist_sel(internal, oid, internal, integer) does not exist CREATE FUNCTION ALTER FUNCTION CREATE FUNCTION ALTER FUNCTION CREATE FUNCTION ALTER FUNCTION ALTER OPERATOR ALTER OPERATOR ALTER OPERATOR ALTER OPERATOR ALTER OPERATOR ALTER OPERATOR ALTER OPERATOR ALTER OPERATOR ALTER OPERATOR ALTER OPERATOR ALTER OPERATOR ALTER OPERATOR ALTER OPERATOR ALTER OPERATOR ALTER OPERATOR ALTER OPERATOR ALTER OPERATOR ALTER OPERATOR ALTER OPERATOR ALTER OPERATOR ALTER OPERATOR ALTER OPERATOR ALTER OPERATOR SET SET CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE SET CREATE TABLE ALTER TABLE SET CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER TABLE ALTER SEQUENCE setval -------- 1 (1 row) CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER TABLE ALTER SEQUENCE setval -------- 1 (1 row) CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER TABLE ALTER SEQUENCE setval -------- 1 (1 row) CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER TABLE ALTER SEQUENCE setval -------- 1 (1 row) CREATE TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ERROR: duplicate key value violates unique constraint "spatial_ref_sys_pkey" DETAIL: Key (srid)=(3310) already exists. CONTEXT: COPY spatial_ref_sys, line 1: "3310 epsg 3310 PROJCS["NAD83 / California Albers",GEOGCS["NAD83",DATUM["North_American_Datum_1983",S..." Done. ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX REVOKE REVOKE GRANT GRANT REVOKE REVOKE GRANT REVOKE REVOKE GRANT GRANT REVOKE REVOKE GRANT GRANT REVOKE REVOKE GRANT REVOKE REVOKE GRANT REVOKE REVOKE GRANT GRANT REVOKE REVOKE GRANT GRANT REVOKE REVOKE GRANT GRANT REVOKE REVOKE GRANT GRANT REVOKE REVOKE GRANT GRANT REVOKE REVOKE GRANT GRANT REVOKE REVOKE GRANT GRANT REVOKE REVOKE GRANT GRANT REVOKE REVOKE GRANT GRANT REVOKE REVOKE GRANT GRANT REVOKE REVOKE GRANT GRANT REVOKE REVOKE GRANT GRANT REVOKE REVOKE GRANT GRANT REVOKE REVOKE GRANT REVOKE REVOKE GRANT GRANT REVOKE REVOKE GRANT GRANT REVOKE REVOKE GRANT GRANT REVOKE REVOKE GRANT GRANT REVOKE REVOKE GRANT GRANT REVOKE REVOKE GRANT GRANT REVOKE REVOKE GRANT GRANT ALTER TABLE