Re: Upgrade 96 -> 11

On 9/1/19 9:03 PM, James Sewell wrote:
> Hi,
>
> I'm in the process of upgrading from 96 -> 11 (on RHEL 7.3) . Both the
> versions have PostGIS 2.5.1 installed and working.
>
> pg_upgrade fails with:
>
> pg_restore: [archiver (db)] Error from TOC entry 440; 1259 537086 TABLE
> tablename databasename
> 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),
>

You used the 11 version of pg_upgrade, correct?

> On looking further at the sequence of events I can see that:
>
> 1. The PostGIS extension is created (but somehow the related tables
> such as spatial_ref_sys do not get created)
> 2. The tablename table gets created causing the above error
> 3. At some point later in the upgrade spatial_ref_sys is to be created

Questions:

1) How was PostGIS installed on the 9.6.? and 11.? versions?
Where extensions used or was the manual method used?

2) Did you end up with a working install in 11.?

>
>
> Is there any way round this type of issue (I guess forcing
> spatial_ref_sys to be created either with the extension as normal or
> just before any tables which rely on it).
>
> 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.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com