[postgis-users] Error on a raster table restore

Cedric Duprez Cedric.Duprez at ign.fr
Thu Jan 14 05:30:32 PST 2016


Hi all,

I am trying to copy a raster table (elevation model) from one server to 
another server.
Both servers have the same configuration : same versions of PostgreSQL 
(9.3.4) and same version of PostGIS (2.1.0).

I perform the backup on the first server like this :
pg_dump -E UTF-8 -Fc -i -O -x -h prodserver.mydomain.fr -p 5432 -U 
myuser -t myschema.mnt proddb > 
/home/myuser/PostgreSQL/backups/mnt2011.backup

Then, on the second server, I restore the raster table like this :
pg_restore -O -h testserver.mydomain.fr -p 5432 -j 4 -U myuser -d testdb 
/home/myuser/PostgreSQL/backups/mnt2011.backup

Everything works perfectly until the data insertions, which produce the 
following error message :
pg_restore: [programme d'archivage (db)] Erreur pendant le traitement de 
la TOC (« PROCESSING TOC ») :
pg_restore: [programme d'archivage (db)] Erreur à partir de l'entrée TOC 
4448 ; 0 30751 TABLE DATA mnt myuser
pg_restore: [programme d'archivage (db)] COPY échoué pour la table « mnt 
» : ERROR:  function st_bandmetadata(public.raster, integer[]) does not 
exist
LIGNE 1 :  SELECT array_agg(pixeltype)::text[] FROM st_bandmetadata($1...
                                                     ^
ASTUCE : No function matches the given name and argument types. You 
might need to add explicit type casts.
REQUÊTE :  SELECT array_agg(pixeltype)::text[] FROM st_bandmetadata($1, 
ARRAY[]::int[]);
CONTEXTE : SQL function "_raster_constraint_pixel_types" during inlining
COPY mnt, line 1: "1 
0100000100000000000000394000000000000039C000000000B76B29410000002035325941000000000000000000000000..."


What's wrong ? "public", where the postgis extension is installed, is in 
the databases default search_path value.

Thanks in advance for your help.

Regards,

Cedric


More information about the postgis-users mailing list