Quantcast

How to install PGCRYPTO in PostgreSQL9

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

How to install PGCRYPTO in PostgreSQL9

Andre Lopes-2
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 ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: How to install PGCRYPTO in PostgreSQL9

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 pgcrypto.sql that comes with the package.

If it is the source installation, run make install under
contrib/pgcrypto directory. Then again, load pgcrypto.sql to your
database.

Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

signature.asc (205 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: How to install PGCRYPTO in PostgreSQL9

Andre Lopes-2
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: ERROR:  permission
denied for language c
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:19: ERROR:  permission
denied for language c
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:24: ERROR:  permission
denied for language c
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:29: ERROR:  permission
denied for language c
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:34: ERROR:  permission
denied for language c
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:39: ERROR:  permission
denied for language c
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:44: ERROR:  permission
denied for language c
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:49: ERROR:  permission
denied for language c
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:54: ERROR:  permission
denied for language c
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:59: ERROR:  permission
denied for language c
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:64: ERROR:  permission
denied for language c
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:72: ERROR:  permission
denied for language c
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:77: ERROR:  permission
denied for language c
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:85: ERROR:  permission
denied for language c
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:90: ERROR:  permission
denied for language c
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:98: ERROR:  permission
denied for language c
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:103: ERROR:  permission
denied for language c
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:111: ERROR:  permission
denied for language c
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:116: ERROR:  permission
denied for language c
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:124: ERROR:  permission
denied for language c
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:129: ERROR:  permission
denied for language c
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:137: ERROR:  permission
denied for language c
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:142: ERROR:  permission
denied for language c
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:150: ERROR:  permission
denied for language c
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:155: ERROR:  permission
denied for language c
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:163: ERROR:  permission
denied for language c
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:168: ERROR:  permission
denied for language c
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:176: ERROR:  permission
denied for language c
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:181: ERROR:  permission
denied for language c
psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:189: ERROR:  permission
denied for language c
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?

Best Regards,


2011/8/17 Devrim GÜNDÜZ <[hidden email]>:

> 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 pgcrypto.sql that comes with the package.
>
> If it is the source installation, run make install under
> contrib/pgcrypto directory. Then again, load pgcrypto.sql to your
> database.
>
> Regards,
> --
> Devrim GÜNDÜZ
> Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
> PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
> Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
> http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz
>

--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: How to install PGCRYPTO in PostgreSQL9

Adrian Klaver-3
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
[hidden email]

--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: How to install PGCRYPTO in PostgreSQL9

Andre Lopes-2
Thanks for the reply. I have installed with the user "postgres" and it
worked. Thanks!


2011/8/17 Adrian Klaver <[hidden email]>:

> 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
> [hidden email]
>

--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Loading...