[postgis-users] Error on a raster table restore

[Tom van Tilburg]

Cedric,

Are you sure rasters are enabled in your new postgis dbase? Please check
for the existence  of raster functions (st_bandmetadata in particular) in
public.functions and run SELECT postgis_full_version()

Tom

On Thu, 14 Jan 2016 14:46 Cedric Duprez <Cedric.Duprez at ign.fr> wrote:

> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20160115/6add88dd/attachment.html>