[postgis-users] Borked PostGIS 2.2 Upgrade

[Lee Hachadoorian]

Paul,

Wow! "Uniquely terrible"!

I *do* have a compatible linux machine (nearly same setups on personal
laptop and at office, and I had not yet tried upgrading office
PostGIS), so I think I will use your last suggestion to copy the data
directory, fire up the cluster, and do a proper dump.

But I still have to get a working PostGIS back on my laptop. I will
read over your blog post and your subsequent email to see what I can
do.

Thanks for the detailed responses.

Best,
--Lee


On Thu, Aug 11, 2016 at 10:46 AM, Paul Ramsey <pramsey at cleverelephant.ca> wrote:
> 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
>>
>>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/postgis-users



-- 
Lee Hachadoorian
Asst Professor of Geography, Dartmouth College
http://freecity.commons.gc.cuny.edu/