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.

Jakob
已提问 2 个月前485 查看次数
1 回答
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
已回答 2 个月前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则