alter extension pos" name="description" /> alter extension pos" />
57001

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

Question:

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

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

The closest resource I could find to address this issue was here: <a href="http://postgis.17.x6.nabble.com/postgis-backend-and-legacy-functions-td5009743.html" rel="nofollow">http://postgis.17.x6.nabble.com/postgis-backend-and-legacy-functions-td5009743.html</a> 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.

<strong>Update</strong> 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.

Answer1:

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.

Recommend

  • PostGIS installed, but unable to select version or add geography columns
  • Make a numpy array monotonic without a Python loop
  • Platform independent way to find path to libpython (e.g., for use in cmake)
  • Linking libjpeg library to a shared library, and libjpeg is undefined at runtime
  • dropdown display just js
  • R: Random sampling an even number of observations from a range of categories
  • Is it possible to reuse Keys in Web.Config?
  • IndexAxisValueFormatter not working as expected
  • How to mount dynamically single file component in Vue.js
  • Entity framework 'include' including more than it should
  • Bullet-Proof ACL using AngularJS
  • parallelize process in missForest package
  • Access Google Maps from outside
  • Getting IIS6 to play nice with WordPress Pretty Permalinks
  • Titanium doesn't recognize Android SDK on Windows
  • How to use tag-it
  • ckeditor and jquery UI dialog not working
  • Most efficient way to move table rows from one table to another
  • Filter strings with regex before casting to numeric
  • JPA flush vs commit
  • How does document.ready work with angular element directives?
  • How can the INSERT … ON CONFLICT (id) DO UPDATE… syntax be used with a sequence ID?
  • Marklogic : Query response time is very high
  • Why querying a date BC is changed to AD in Java?
  • Record samples being played with OpenAL
  • PostgreSQL Query without WHERE only ORDER BY and LIMIT doesn't use index
  • Lost migrations and Azure database is now out of sync
  • DirectX11 ClearRenderTargetViewback with transparent buffer?
  • Deserializing XML into class C#
  • Why is the timeout on a windows udp receive socket always 500ms longer than set by SO_RCVTIMEO?
  • Large data - storage and query
  • ORA-29908: missing primary invocation for ancillary operator
  • Web-crawler for facebook in python
  • How to get next/previous record number?
  • How to include full .NET prerequisite for Wix Burn installer
  • Unit Testing MVC Web Application in Visual Studio and Problem with QTAgent
  • How do you join a server to an Active Directory (domain)?
  • How does Linux kernel interrupt the application?
  • costura.fody for a dll that references another dll
  • jQuery Masonry / Isotope and fluid images: Momentary overlap on window resize