[postgis-users] Upgrade issues

[Darafei "Komяpa" Praliaskouski]

Hi,

By the looks of it - you have a geography, not geometry, column, with a
SRID set. As far as I remember, geography looks up the SRID in the
spatial_ref_sys table to check if it's indeed a degrees-on-a-spheroid one.
This probably needs a ticket on https://trac.osgeo.org/postgis/.

On Mon, Sep 2, 2019 at 5:59 AM James Sewell <james.sewell at jirotech.com>
wrote:

> Hi all,
>
> I'm upgrading from 9.6 -> 11. Both versions have PostGIS 2.5.1.
>
> The upgrade starts then I see this in the logs:
>
> pg_restore: [archiver (db)] could not execute query: ERROR:  relation
> "public.spatial_ref_sys" does not exist
> LINE 39:     "location_pt" "public"."geography"(Point,4283),
>
> Above this I can see:
>
> pg_restore: creating EXTENSION "postgis"
>
> This is created fine - it just doesn't make the PostGIS tables in any
> schema?
>
> Has anyone seen anything like this before?
>
> Cheers,
>
> James Sewell,
>
>
> ------------------------------
> The contents of this email are confidential and may be subject to legal or
> professional privilege and copyright. No representation is made that this
> email is free of viruses or other defects. If you have received this
> communication in error, you may not copy or distribute any part of it or
> otherwise disclose its contents to anyone. Please advise the sender of your
> incorrect receipt of this correspondence.
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users



-- 
Darafei Praliaskouski
Support me: http://patreon.com/komzpa
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190903/3f7188f4/attachment.html>