从PostGIS 2.1升级:“错误:尝试重新定义参数" postgis.backend". [英] Upgrading from PostGIS 2.1: "Error: attempt to redefine parameter "postgis.backend"

问题描述

从PostGIS 2.1升级:错误:尝试重新定义参数"postgis.backend"

Upgrading from PostGIS 2.1: "Error: attempt to redefine parameter "postgis.backend"

我正在尝试在AWS RDS上升级PostGIS数据库，但是运行ALTER EXTENSION postgis UPDATE时出现错误，如下所示:

I am trying to upgrade my PostGIS database on AWS RDS, but I am getting an error when running ALTER EXTENSION postgis UPDATE, as shown below:

my_db=> alter extension postgis update;
ERROR:  attempt to redefine parameter "postgis.backend"

这是有关我的数据库的一些其他信息:

And here is some additional information about my database:

my_db=> select distinct probin from pg_proc where probin like '%postgis%';
-[ RECORD 1 ]-----------------
probin | $libdir/rtpostgis-2.1
-[ RECORD 2 ]-----------------
probin | $libdir/postgis-2.1

my_db=> select version();
-[ RECORD 1 ]-----------------------------------------------------------------------------------------------------
version | PostgreSQL 9.5.9 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.2 20140120 (Red Hat 4.8.2-16), 64-bit

my_db=> select postgis_full_version();
-[ RECORD 1 ]--------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
postgis_full_version | POSTGIS="2.1.8 r13780" GEOS="3.5.1-CAPI-1.9.1 r4246" PROJ="Rel. 4.9.2, 08 September 2015" GDAL="GDAL 1.11.5, released 2016/07/01" LIBXML="2.9.1" LIBJSON="UNKNOWN" TOPOLOGY RASTER

我可以找到解决这个问题的最接近的资源是: http://postgis.17.x6.nabble.com/postgis-backend-and-legacy-functions-td5009743.html ，尽管该问题涉及引用多个PostGIS版本.似乎我遇到了相同的错误，但是我的错误可能有不同的原因，因为如上所述，我仅引用postgis-2.1和rtpostgis-2.1.任何建议，将不胜感激.

The closest resource I could find to address this issue was here: http://postgis.17.x6.nabble.com/postgis-backend-and-legacy-functions-td5009743.html although that issue involved referencing multiple PostGIS versions. It seems that I am getting the same error, but my error may have a different cause, because I am only referencing postgis-2.1 and rtpostgis-2.1, as shown above. Any suggestions would be appreciated.

更新 这似乎是与RDS有关的问题，几分钟后，我看到一个补丁通过事件日志应用于RDS.应用补丁后，运行alter extension postgis update命令成功升级PostGIS扩展.现在结束这个问题.

Update This seems to be an issue related to RDS, where after a minutes I saw that a patch is applied to RDS via the event logs. After the patch is applied, running the alter extension postgis update command successfully upgrade the PostGIS extension. Closing this question for now.

推荐答案

这似乎是与RDS有关的问题，几分钟后，我看到通过事件日志将补丁应用于RDS.应用补丁后，运行alter extension postgis update命令成功升级PostGIS扩展.现在结束这个问题.

This seems to be an issue related to RDS, where after a minutes I saw that a patch is applied to RDS via the event logs. After the patch is applied, running the alter extension postgis update command successfully upgrade the PostGIS extension. Closing this question for now.

这篇关于从PostGIS 2.1升级:“错误:尝试重新定义参数" postgis.backend".的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！