[postgis-devel] Upgrade PG 9.3 to 9.5 with PostGIS issue

[Blumentrath, Stefan]

Hi Sandro,

And thanks for your reply. I use:

/usr/lib/postgresql/9.5/bin/pg_upgrade -d /data/postgresql/9.3/main -D /data/postgresql/9.5/main -b /usr/lib/postgresql/9.3/bin -B /usr/lib/postgresql/9.5/bin -p 5432 -P 5433 -v -j 10

So I do not dump/restore. pg_upgrade complains when the target cluster is not empty, so I don`t think it is possible to add postgis to the "target database", in fact there is no target database, so I did not read the FAQ carefully enough - sorry...

Cheers
Stefan


-----Original Message-----
From: Sandro Santilli [mailto:sandro.santilli at gmail.com] On Behalf Of Sandro Santilli
Sent: 6. april 2016 14:16
To: Blumentrath, Stefan <Stefan.Blumentrath at nina.no>
Cc: PostGIS Development Discussion <postgis-devel at lists.osgeo.org>; Åström, Jens <Jens.Astrom at nina.no>
Subject: Re: [postgis-devel] Upgrade PG 9.3 to 9.5 with PostGIS issue

On Wed, Apr 06, 2016 at 10:25:29AM +0000, Blumentrath, Stefan wrote:

> pg_restore: [archiver (db)] could not execute query: ERROR:  operator 
> does not exist: public.geometry && public.geometry

Did you add postgis to the target database prior to restore the data from the dump ?
Did you use postgis_restore.pl ?

--strk;