[postgis-users] Borked PostGIS 2.2 Upgrade

[Paul Ramsey]

Actually, your situation is rather uniquely terrible Lee, in that after
running your "upgrade" you seem to have no copy of the postgis.so library
left at all. So the hacks in my blog are not useful to you, as they assume
that at lest there's a new/old copy of the so file lying around.

You'll need to get a copy of the so. You could hand-copy one out of a
compatible linux distro, for example. Or you could grab the postgis source,
download the dev packages for postgresql for your distro, and build one for
yourself. Either option holds possibilities.

Another possibility if you have a compatible linux machine lying around:
copy the whole postgresql data directory over and start it up over there.
Requires identical architecture (32/64) and pgsql/postgis versions.

ATB,

P

On Thu, Aug 11, 2016 at 7:42 AM, Paul Ramsey <pramsey at cleverelephant.ca>
wrote:

> Your SE question inspired me to write up a post which has some remedies in
> the final section
>
> http://blog.cleverelephant.ca/2016/08/postgis-upgrade.html
>
> P
>
> On Wed, Aug 10, 2016 at 9:08 PM, Lee Hachadoorian <
> Lee.Hachadoorian+L at gmail.com> wrote:
>
>> Running PostGIS on PostgreSQL 9.3 Linux Mint 17.2 using
>> ubuntugis-unstable PPA. I had a working PostGIS 2.1.4. I recently apt
>> upgraded to PostGIS 2.2.2. I then tried:
>>
>>     ALTER EXTENSION postgis UPDATE TO "2.2.2";
>>
>> However this resulted in:
>>
>>     ERROR:  could not access file "$libdir/postgis-2.2": No such file
>> or directory
>>
>> I posted about this to GIS.SE
>> (http://gis.stackexchange.com/questions/206412/how-can-i-do-
>> a-soft-upgrade-from-postgis-2-1-4-to-2-2-2).
>> Paul Ramsey responded and helped me figure out that something went
>> wrong with upgrade. (Thanks Paul!) At this point, I need to figure out
>> whether I can salvage the installation. I wanted to avoid dump and
>> restore, but at this point even dump is not working because of
>> nonworking PostGIS. I'm moving this to postgis-users as the
>> back-and-forth is more appropriate to a ML than GIS.SE
>>
>> I'm running into dependency issues. I was *not* able to downgrade
>> because PostGIS 2.1 depends on GDAL 1.x, and I have already upgraded
>> to GDAL 2.0. When I looked to see what would be involved in
>> downgrading GDAL, apt wants to uninstall QGIS 2.16 and a bunch of
>> other stuff.
>>
>> I apt uninstalled PostGIS 2.2 and reinstalled PostGIS 2.2. That
>> database still thinks it's on PostGIS 2.1, which is missing, and
>> CREATE EXTENSION fails (no control file) and ALTER EXTENSION fails as
>> previously.
>>
>> Best,
>> --Lee
>>
>>
>>
>>
>>
>> --
>> Lee Hachadoorian
>> Asst Professor of Geography, Dartmouth College
>> http://geospatial.commons.gc.cuny.edu/
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/postgis-users
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20160811/e4e9a29e/attachment.html>