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

gregmcavoy · 12-29-2003, 11:37 AM

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