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 個月前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南