access to library 'age' is not allowed for database user #1197
Replies: 2 comments
-
For non-super user we always use
We add those automatically for all scripts (java service) |
Beta Was this translation helpful? Give feedback.
0 replies
-
Turns out there was a corrupted age extension in the database cluster which was unable to be removed. |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Have successfully built the apache/age extension from source for Postgresql 15.
Have ensured that the database user I have created has access to the schema ag_catalog.
Also have created the link from /usr/lib/postgresql/15/lib/age.so to /usr/lib/postgresql/15/lib/plugins/age.so.
running the statement "load 'age'" as user postgres works. However as the db user it results in the message "ERROR: access to library "age" is not allowed".
Any assistance welcome.
Beta Was this translation helpful? Give feedback.
All reactions