Re: [GENERAL] How to install PGCRYPTO in PostgreSQL9

2011-08-17 Thread Andre Lopes
Thanks for the reply. I have installed with the user "postgres" and it worked. Thanks! 2011/8/17 Adrian Klaver : > 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 >> /

Re: [GENERAL] How to install PGCRYPTO in PostgreSQL9

2011-08-17 Thread Adrian Klaver
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 >

Re: [GENERAL] How to install PGCRYPTO in PostgreSQL9

2011-08-17 Thread Andre Lopes
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:9: ERROR: permission denied for language c psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:14: ERRO

Re: [GENERAL] How to install PGCRYPTO in PostgreSQL9

2011-08-17 Thread Devrim GÜNDÜZ
On Wed, 2011-08-17 at 06:28 -0700, Andre Lopes wrote: > > I am using CentOS and PostgreSQL9. I have an application that uses > Pgcrypto. I have googled but I am not sure how can I install this in > PostgreSQL9. If you are using RPMS, then install -contrib RPM, and then install pgcrypto using pgc

[GENERAL] How to install PGCRYPTO in PostgreSQL9

2011-08-17 Thread Andre Lopes
Hi, I am using CentOS and PostgreSQL9. I have an application that uses Pgcrypto. I have googled but I am not sure how can I install this in PostgreSQL9. Someone can give me a clue on this? Best Regards, -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to yo