jrgemignani commented on issue #839: URL: https://github.com/apache/age/issues/839#issuecomment-1520559219
@CC-Hsu > Although the [LOAD command](https://www.postgresql.org/docs/current/sql-load.html) is superuser-restricted, it may be replaced by setting [local_preload_libraries](https://postgresqlco.nf/doc/en/param/local_preload_libraries/) GUC, so that LOAD command can be skipped and allow non-superuser DB roles to use Apache AGE objects. From the link for load - > Non-superusers can only apply LOAD to library files located in $libdir/plugins/ — the specified filename must begin with exactly that string. (It is the database administrator's responsibility to ensure that only “safe” libraries are installed there.) We do not install AGE there by default for security reasons as this is the job of the DBA for that database. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
