Thanks for the reply. I have installed with the user "postgres" and it worked. Thanks! 2011/8/17 Adrian Klaver <adrian.klaver@xxxxxxxxx>: > On Wednesday, August 17, 2011 6:44:31 am Andre Lopes wrote: >> I have installed and tried to import the SQL, but I got this: >> >> [code] >> [andre@andre public]$ psql -d 420 -f >> /usr/pgsql-9.0/share/contrib/pgcrypto.sql SET > >> psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:197: ERROR: permission >> denied for language c >> psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:202: ERROR: permission >> denied for language c >> [andre@andre public]$ >> [/code] >> >> What's wrong here? > > Would seem to indicate you did not install as database superuser. > >> > > > -- > Adrian Klaver > adrian.klaver@xxxxxxxxx > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
