Re: Upgrade 96 -> 11

On Tue, 3 Sep 2019 at 7:15 am, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 9/2/19 2:04 PM, James Sewell wrote:
> Please reply to list also.
> Ccing list.
> >
> >
> > On Mon, 2 Sep 2019 at 11:56 pm, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> > <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
> >
> > 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?
> >
> >
> > 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?
> >
> >
> > Both from extensions, although 9.6 was and older version which was
> > upgraded (with ALTER)
> >
> >
> >
> > 2) Did you end up with a working install in 11.?
> >
> >
> > Yes. If I create a cluster and start it and create the extension all is
> > fine (postgis tabkes created).
>
> So this is a separate cluster from the one you used pg_upgrade on?

In that case yes it was seperate

>
> In other words when doing pg_upgrade you could not get a working
> cluster, correct?

Pg_upgrade does not complete - but as it hasn’t started migrating data I
can start it and it’s fine (except for postgis which is now in a partial
install state)

>
>
>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
--
James Sewell,
Chief Architect

Suite 112, Jones Bay Wharf, 26-32 Pirrama Road, Pyrmont NSW 2009
P (+61) 2 8099 9000 W www.jirotech.com F (+61) 2 8099 9099

--
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.