CREATE EXTENSION without superuser access
От | Steve Atkins |
---|---|
Тема | CREATE EXTENSION without superuser access |
Дата | |
Msg-id | D876ECB7-1CEA-4BEC-AE8A-810751CD8871@blighty.com обсуждение исходный текст |
Ответы |
Re: CREATE EXTENSION without superuser access
Re: CREATE EXTENSION without superuser access |
Список | pgsql-general |
I have an app that would benefit from being able to use pg_partman rather than doing it's own ad-hoc partition management. Unfortunately, some of the places where the app needs to run don't have root access to the database server filesystem, soI can't install the extension in the postgresql extensions directory. I could get all the pg_partman functionality by modifying the extension SQL script to remove the extension functionalityand installing the functions in it manually, but then I can't take advantage of the extension features for backups,config tables, upgrades and so on - and it's probably not going to interact well if someone does a "create extensionpg_partman" in the database. Is there any way to install an extension either from a SQL connection or from a user-defined directory instead of .../extensions? (And if not, is there a TODO here?) Cheers, Steve
В списке pgsql-general по дате отправления: