[postgis-users] ERROR: transform: Point outside of projection domain (2050)

[pham lan]

Hi Regina,

Here are more information:

geodm=# SELECT postgis_full_version();

                   postgis_full_version

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------
 POSTGIS="2.5.5" [EXTENSION] PGSQL="100" GEOS="3.9.2-CAPI-1.14.3"
PROJ="Rel. 7.2.1, January 1st, 2021" GDAL="GDAL 3.2.3, released 2021/04/27"
LIBXML="2.9.7" LIBJSON="0.13.1" LIBPROTOBUF="1.3.0"
TOPOLOGY RASTER
(1 row)

[image: grafik.png]


On Mon, Mar 27, 2023 at 9:43 PM Regina Obe <lr at pcorp.us> wrote:

> What’s the structure of the table in question?
>
>
>
> \d+ name_of_table
>
>
>
> Should give needed details.
>
>
>
> Also output of
>
>
>
> SELECT postgis_full_version();
>
>
>
> *From:* postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] *On
> Behalf Of *pham lan
> *Sent:* Monday, March 27, 2023 3:27 PM
> *To:* PostGIS Users Discussion <postgis-users at lists.osgeo.org>
> *Subject:* [postgis-users] ERROR: transform: Point outside of projection
> domain (2050)
>
>
>
> Hi everyone,
>
>
>
> I need your help to figure this out. I have a DB in postgresql 10  with
> postgis 2.5. I know postgresql 10 is not supported anymore and we have plan
> to upgrade it soon but it is a different story.
>
> The thing is, I want to make a copy of this DB, so I tried a pg_basebackup
> to another postgres10+postgis 2.5 VM. After that, a vacuum went well but
> the analyzer throws an error on 1 specific table:
>
> *ERROR:  transform: Point outside of projection domain (2050)*
>
> i tried also pg_dump/pg_restore but get the same error. Does anyone know
> what is the problem?
>
>
>
> Thanks for your help!
>
> Regards,
>
> Lan
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20230327/ff75d12c/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: grafik.png
Type: image/png
Size: 166141 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20230327/ff75d12c/attachment.png>