Search Postgresql Archives

Re: CREATE EXTENSION without superuser access

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> On Apr 27, 2016, at 2:47 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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 functionality and 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 extension pg_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 relative to 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.

Cheers,
  Steve



-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux