Re: [GENERAL] CREATE EXTENSION without superuser access

2016-04-28 Thread Steve Atkins
> On Apr 28, 2016, at 6:44 AM, Vik Fearing wrote: > > On 04/27/2016 10:22 PM, Steve Atkins wrote: >> 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?) > > There is actu

Re: [GENERAL] CREATE EXTENSION without superuser access

2016-04-28 Thread Vik Fearing
On 04/27/2016 10:22 PM, Steve Atkins wrote: > 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?) There is actually a TODON'T here. Search the pgsql-hackers archives for some v

Re: [GENERAL] CREATE EXTENSION without superuser access

2016-04-27 Thread Adrian Klaver
On 04/27/2016 04:06 PM, Steve Atkins wrote: On Apr 27, 2016, at 3:47 PM, Adrian Klaver wrote: On 04/27/2016 03:30 PM, Steve Atkins wrote: 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,

Re: [GENERAL] CREATE EXTENSION without superuser access

2016-04-27 Thread Steve Atkins
> On Apr 27, 2016, at 3:47 PM, Adrian Klaver wrote: > > On 04/27/2016 03:30 PM, Steve Atkins wrote: >> 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 wan

Re: [GENERAL] CREATE EXTENSION without superuser access

2016-04-27 Thread Adrian Klaver
On 04/27/2016 03:30 PM, Steve Atkins wrote: On Apr 27, 2016, at 2:47 PM, Adrian Klaver 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 pl

Re: [GENERAL] CREATE EXTENSION without superuser access

2016-04-27 Thread David G. Johnston
On Wed, Apr 27, 2016 at 2:47 PM, Adrian Klaver 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

Re: [GENERAL] CREATE EXTENSION without superuser access

2016-04-27 Thread Steve Atkins
> On Apr 27, 2016, at 2:47 PM, Adrian Klaver 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 ru

Re: [GENERAL] CREATE EXTENSION without superuser access

2016-04-27 Thread Adrian Klaver
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

[GENERAL] CREATE EXTENSION without superuser access

2016-04-27 Thread Steve Atkins
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 ex