Re: CREATE EXTENSION without superuser access

On 04/27/2016 03:30 PM, Steve Atkins wrote:
>
>> On Apr 27, 2016, at 2:47 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>>
>> On 04/27/2016 01:22 PM, Steve Atkins wrote:
>>> 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,so I 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?
>>
>> Have not tried it, but you might want to take a look at:
>>
>> http://www.postgresql.org/docs/9.5/interactive/extend-extensions.html
>>
>> A control file can set the following parameters:
>>
>> directory (string)
>>
>>     The directory containing the extension's SQL script file(s). Unless an absolute path is given, the name is
relativeto the installation's SHAREDIR directory. The default behavior is equivalent to specifying directory =
'extension'.
>
> That's a useful feature, for sure, but I think the control file itself still needs to be in the .../extensions
directory.

Yeah, that would be a problem, I needed to read a couple of paragraphs
up from the above:(

Got to thinking, when you say root do you really mean root or the user
the database cluster is initdb'ed as?

>
> Cheers,
>    Steve
>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com