Just as a big hammer fix: UPDATE pg_proc SET probin = '$libdir/postgis-2.2' WHERE probin = '$libdir/postgis-2.1';
P. On Wed, Apr 13, 2016 at 2:35 AM, Armand Turpel <armand.turpel.m...@gmail.com> wrote: > Hi Paul, > Here the result: > > "$libdir/postgis-2.2" > "$libdir/postgis-2.1" > "$libdir/rtpostgis-2.2" > > Armand > > > > On 12/04/2016 17:50, Paul Ramsey wrote: >> >> What does this query return? >> >> select distinct probin from pg_proc where probin like '%postgis%'; >> >> On Tue, Apr 12, 2016 at 2:32 AM, Armand Turpel >> <armand.turpel.m...@gmail.com> wrote: >>> >>> Hi, >>> >>> I have a wired problem after upgrading from pg 9.1 postgis 1.5 to pg 9.3 >>> postgis 2.2.1 >>> >>> On some tables with a geometry column the error appear: >>> >>> attempt to redefine parameter "postgis.backend" >>> >>> even if a query dosent contains the geometry column. >>> >>> On other tables which have a geometry column too the problem dosent >>> appear. >>> May some geometry columns are corrupted. >>> >>> I guess i have done some thing wrong with the pg/postgis upgrade. The >>> mess >>> is done. Since the last upgrade, 2 weeks, the database is in production. >>> I >>> cant easily restore the old database. >>> Is there a way to fix this problem? >>> >>> Thanks for helping, >>> atu >>> >>> >>> _______________________________________________ >>> postgis-users mailing list >>> postgis-users@lists.osgeo.org >>> http://lists.osgeo.org/mailman/listinfo/postgis-users >> >> _______________________________________________ >> postgis-users mailing list >> postgis-users@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/postgis-users > > > _______________________________________________ > postgis-users mailing list > postgis-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/postgis-users