Re: array_agg for 8.3

On Mon, 19 Jan 2009, Jeff Davis wrote:

> On Mon, 2009-01-19 at 13:40 -0500, Faheem Mitha wrote:
>> In any case, I don't have admin permissions on the machine I'm trying to
>> install it to.
>
> At absolute minimum, you need PostgreSQL superuser privileges. If you
> don't, you need to set up a new PostgreSQL instance (which you can do as
> a normal non-root user), and then you will have superuser privileges for
> your own instance.
>
> If you do have PostgreSQL superuser privileges, but not root on the
> machine, you can install the module to some other location by changing
> some paths around, although that might be slightly ugly.

Hi Jeff,

Yes, I have pg superuser privileges. I *think* this is the same as having
sudo rights for postgres, right? Are you suggesting adding another entry
to the library path, or whatever this is called? Like ~/.postgresql/ or
something like that?

To be clear, even if I have admin on the machine, it is generally
undesirable to install unpackaged software to the machine, so I'd have to
package it first. I guess that is an option if I find I am using it a lot.

Is there any major downside to the way I'm doing it, as described in my
last message?

Thanks again for your help.
Regards, Faheem.