Re: installin postgresql-contrib

[Alexei Chetroi <debian@lexa.uniflux-line.net>]

On Thu, Sep 18, 2003 at 10:54:49AM +0100, Oliver Elphick wrote:
 > 
> >  I want to add some function to postgres database from
> > postgresql-contrib package (some encryption functions). Packages install
> > normally, but when I'm trying to add functions to database it complains:
> > 
> > [lex.lexa]$ psql mf </usr/lib/postgresql/contrib/pgcrypto.sql 
> > SET
> > SET
> > ERROR:  c: permission denied
> > ERROR:  c: permission denied
> 
> You will find it easier to understand what is happening if you use the
> -e option to psql, which will show you the queries that are being
> executed.  This is the start of the sql script:
> 
>         -- Adjust this setting to control where the objects get created.
>         SET search_path = public;
[SKIP]

> I think that your problem is that you (the current postgresql user) does
> not have permission to create a C language function.  Such a function
> would have complete access to any database structures and could be used
> to bypass access security, so you should probably be running as postgres
> superuser to do this successfully.
> 
 Thank you very much. Indeed I've ran this script as ordinary user, no
as postgres user. That was a problem, now everything works ok. Thanks.