Hi Regina,
Thanks a lot for your help and for the bug report.
The temporary fix worked also for me.
Regards,
Cedric
___
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
>
> http://www.postgis.us
>
> http://postgis.net
>
>
>
>
>
>
>
>
>
>
>
> *From:* postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] *On
> Behalf Of *Shane StClair
> *Sent:* Tuesday, May 02, 2017 3:55 PM
> *To:* postgis-users@lists.osgeo.o
http://postgis.net
From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of
Shane StClair
Sent: Tuesday, May 02, 2017 3:55 PM
To: postgis-users@lists.osgeo.org
Subject: Re: [postgis-users] Restore a raster dump from PostGIS 2.1.0 to
PostGIS 2.3.0
Was a sol
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
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 installation:
apt-get update && apt-get install -y postgresql-9.3 postgresql-c
Hi,
Still same issue with two servers having the same configuration.
Regards,
Cedric
Le 21/11/2016 à 11:16, Cedric Duprez a écrit :
That's right... On the target instance, the user is not exactly the same
as on the original instance.
This is due to a global settings backup problem I am trying
That's right... On the target instance, the user is not exactly the same
as on the original instance.
This is due to a global settings backup problem I am trying to solve.
I will try again with the same users and tell you if it works.
Thanks for your help.
Regards,
Cedric
_
Hi Cedric,
2016-11-21 9:26 GMT+01:00 Cedric Duprez :
> 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
Hi Giuseppe,
Thanks for your answer and your help.
Here is the output of \do @:
Schéma | Nom | Type de l'arg. gauche | Type de l'arg. droit | Type
du résultat |Description
+-+---+--+--+-
Hi Cedric,
2016-11-18 14:21 GMT+01:00 ced :
> Hi all,
>
> I am upgrading PostgreSQL and PostGIS from 9.3/2.1 to 9.5/2.3.
>
> I perform the backup on the old server (9.3/2.1) like this using pg_dump.
>
> Then, on the new server (9.5/2.3), I restore the backup using pg_restore.
>
> Everything is co
Hi all,
I am upgrading PostgreSQL and PostGIS from 9.3/2.1 to 9.5/2.3.
I perform the backup on the old server (9.3/2.1) like this using pg_dump.
Then, on the new server (9.5/2.3), I restore the backup using pg_restore.
Everything is correctly restored, except just one raster table, a DEM, whic
11 matches
Mail list logo
