Search Postgresql Archives

Re: array_agg for 8.3

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

 





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.

--
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