Arch Linux

ES

Member

Registered: 2009-03-13

Posts: 21

[Solved] PostgreSQL: install pgcrypto

Hey all!

I am looking for a way to install the pgcrypto module for postgresql, but I have no clue on how to do it...
(I am using the postgresql from the extra repo)

Any help/suggestion will be greatly appreciated

Cheers,
Eric.

Last edited by ES (2009-03-16 01:36:02)

ES

Member

Registered: 2009-03-13

Posts: 21

Re: [Solved] PostgreSQL: install pgcrypto

OK, There was a postgresql-contrib package in the AUR, with pgcrypto and a lot more!

and if it can helps somebody, how to enable pgcrypto on a db:
#su - postgres
#psql -d DBNAME -f /usr/share/postgresql/contrib/pgcrypto.sql

Cheers,
Eric.

Last edited by ES (2009-03-16 05:21:03)