By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Unable to install postgis extension on postgresql 16.4

1

Hi

After upgrading an existing Postgres 16.1 instance on RDS to 16.4 the postgres extension stopped working. Queries on tables using the extension just fails with this error.

ERROR:  could not load library "/rdsdbbin/postgres-16.4.R1/lib/postgis-3.so": libpsl.so.5: cannot open shared object file: No such file or directory 

SQL state: 58P01

As it was a test db, I removed the tables and dropped the extension. When I try to add it again using CREATE EXTENSION postgis; it results in the same error as above.

Topics
DatabaseMigration & ModernizationAnalytics
Tags
PostgreSQLAmazon Relational Database Service
Language
English
Jakob
asked 2 months ago469 views
1 Answer
0

I was able to resolve this by applying a pending OS update from the Maintenance panel. It seems to have installed the library.

Allan A
answered 2 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content