From: | "Chris Travers" <chris(at)travelamericas(dot)com> |
---|---|
To: | <gregmj(at)sbcglobal(dot)net>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Installed postgresql 7.4 on Redhat 9.0 but can't run pgcrypto.sql |
Date: | 2004-01-05 02:46:41 |
Message-ID: | 00c201c3d33a$0960d250$af44053d@winxp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Try psql -U postgres instead.
Or make sure that gregory has superuser privilages:
ALTER USER gregory WITH CREATE USER; (you would need to be logged in as a superuser in order to do this).
C is an untrusted language so you need superuser privilages to install functions.
Best Wishes,
Chris Travers
----- Original Message -----
From: Greg McAvoy-Jensen
To: pgsql-general(at)postgresql(dot)org
Sent: Tuesday, December 30, 2003 8:13 AM
Subject: [GENERAL] Installed postgresql 7.4 on Redhat 9.0 but can't run pgcrypto.sql
I'm installing a CMS called ezpublish on my Redhat 9.0 machine. I've needed to install a php 4.4 and a newer postgresql (I also installed apache2.0.48, and the later two went into the non-redhat-standard location of /usr/local). ezpublish requires that I run pgcrypto.sql on my database gregorybooks, but I get this interaction after I su postgres:
code:
------------------------------------------------------------------------------
bash-2.05b$ psql -U gregory gregorybooks < /usr/share/pgsql/contrib/pgcrypto.sql
SET
SET
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
------------------------------------------------------------------------------
I actually had success with pgcrypto on the postgresql 7.3 that came with redhat 9, but I installed 7.4 to have a /usr/local/pgsql main directory to point php to and now have this error. What have I done differently? I tried to fix it by making postgres owner of all the pgsql directories. What needs to be fixed? Thank you.
Greg
From | Date | Subject | |
---|---|---|---|
Next Message | Carlos Moreno | 2004-01-05 02:50:30 | Re: PostgreSQL 7.4.1 incredibly slow :-( |
Previous Message | Stephen J Peck | 2004-01-05 02:14:14 | Backend start-up failed FATAL : non-superuser connection limit exceeded |