[postgis-users] Restore a raster dump from PostGIS 2.1.0 to PostGIS 2.3.0
shane at axiomdatascience.com
Tue May 2 12:54:46 PDT 2017
Was a solution to this problem ever discovered? I'm running into exactly
the same problem (backup from PostGIS 2.1 with raster tables can't be
restored to PostGIS 2.3).
HINT: No operator matches the given name and argument type(s). You might
need to add explicit type casts.
QUERY: SELECT $1 @ $2 AND public._ST_CoveredBy($1,$2)
CONTEXT: SQL function "st_coveredby" during inlining
COPY coei_166_3857, line 1: "1
pg_restore: [archiver (db)] Error from TOC entry 187538; 0 223203 TABLE
DATA coei_196_3857 asdf
pg_restore: [archiver (db)] COPY failed for table "coei_196_3857": ERROR:
operator does not exist: public.geometry @ public.geometry
LINE 1: SELECT $1 @ $2 AND public._ST_CoveredBy($1,$2)
On Fri, Nov 25, 2016 at 6:48 AM Cedric Duprez <Cedric.Duprez at ign.fr> wrote:
> Sorry, I thought I had installed PostGIS 2.1 on my backup server, but it
> is 2.3 that has been finally installed.
> I don't understand how that could be.
> The server is on Debian Jessie, and I did the following packages
> apt-get update && apt-get install -y postgresql-9.3 postgresql-client-9.3
> postgresql-contrib-9.3 postgresql-server-dev-9.3 && \
> apt-get install -y gdal-bin libgdal-dev && \
> apt-get install -y postgresql-9.3-postgis-2.1
> Why do I get the 2.3 version of PostGIS installed? How can I downgrade to
> Thanks for you help.
> Still same issue with two servers having the same configuration.
> postgis-users mailing list
> postgis-users at lists.osgeo.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users