Installed postgresql 7.4 on Redhat 9.0 but can't run pgcrypto.sql

From: "Greg McAvoy-Jensen" <gjensen(at)holytrinityparish(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Installed postgresql 7.4 on Redhat 9.0 but can't run pgcrypto.sql
Date: 2003-12-30 01:13:46
Message-ID: 000001c3ce72$2cf25b20$3e0a0a0a@HolyTrinity.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Browne 2003-12-30 02:01:45 Some Documentation Changes
Previous Message Dustin Sallings 2003-12-30 01:00:35 Re: Is my MySQL Gaining ?