Re: help needed with error during upgrade (9.4 -> 9.5)

in the end i took these steps:

- reverted back to 9.4
- connected to each of the databases and checked postgis version:
select distinct probin from pg_proc where probin IS NOT null order by probin
- i discovered i did not need databases with postgis-2.1 anyway (although
template_postgis had to go too), so i dropped them
- upgrade to 9.5 went fine

j

On Thu, Mar 3, 2016 at 8:03 PM, Jozef Riha <jose1711(at)gmail(dot)com> wrote:

> hello list,
>
> i wonder if anyone can give me a helping hand with the issue i am
> experiencing during an attempted to upgrade from postgres 9.4 to 9.5.
>
> the steps i took so far (on my archlinux system):
> - first i upgraded postgresql and postgresql-libs (from 9.4.5 to 9.5.1)
> - followed steps described at
> https://wiki.archlinux.org/index.php/PostgreSQL#Quick_guide
> - pg_upgrade terminated with the following error:
> Could not load library "$libdir/postgis-2.2"
> ERROR: incompatible library "/usr/lib/postgresql/postgis-2.2.so":
> version mismatch
> DETAIL: Server is version 9.5, library is version 9.4.
> - i upgraded postgis from 2.2.0 to 2.2.1 and ran pg_upgrade again.
>
> this time it ended with a different error but now i am unable to proceed
> any further (no idea which way to take it from here):
> ..
> Checking for presence of required libraries fatal
>
> Your installation references loadable libraries that are missing from the
> new installation. You can add these libraries to the new installation,
> or remove the functions using them from the old installation. A list of
> problem libraries is in the file:
> loadable_libraries.txt
>
> Failure, exiting
> $ cat loadable_libraries.txt
> Could not load library "$libdir/postgis-2.2"
> ERROR: attempt to redefine parameter "postgis.backend"
>
> oddly enough i can see postgis-2.2 in both 9.4 and the new installation:
> /opt/pgsql-9.4/lib/postgis-2.2.so
> /usr/lib/postgresql/postgis-2.2.so
>
> any help or advice is welcome.
>
> thank you, jose
>