[postgis-users] attempt to redefine parameter "postgis.backend"

[Paul Ramsey]

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.mnhn at 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.mnhn at 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 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
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/postgis-users