[postgis-users] Restore a raster dump from PostGIS 2.1.0 to PostGIS 2.3.0

[Giuseppe Broccolo]

Hi Cedric,

2016-11-21 9:26 GMT+01:00 Cedric Duprez <Cedric.Duprez at ign.fr>:

> Hi Giuseppe,
>
> Thanks for your answer and your help.
> Here is the output of \do @:
>

The operator signs related to PostGIS datatypes are the following ones:


>     Schéma   | Nom | Type de l'arg. gauche | Type de l'arg. droit | Type
> du résultat |        Description
> ------------+-----+-----------------------+-----------------
> -----+------------------+----------------------------
>   public     | @   | geometry              | geometry             |
> boolean          |
>   public     | @   | geometry              | raster               |
> boolean          |
>   public     | @   | raster                | geometry             |
> boolean          |
>   public     | @   | raster                | raster               |
> boolean          |
>
> The @ operator for raster type is in the public schema.
> Weird, isn't it?


This is due to how the dump has been restored in the target instance
(PostgreSQL 9.5 + PostGIS 2.3).
Functions and operators have been imported in the public schema in the
session opened by pg_restore.

PostGIS 2.1 does not fully-qualify functions and operators, so are not
recreated in the original schemas
when they are restored from a logical backup.

Which user is used to connect to the database when pg_restore is executed?

Regards,
Giuseppe.

-- 
Giuseppe Broccolo - 2ndQuadrant Italy
PostgreSQL & PostGIS Training, Services and Support
giuseppe.broccolo at 2ndQuadrant.it | www.2ndQuadrant.it
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20161121/ea38480c/attachment.html>