On Mon, Aug 13, 2007 at 07:36:41PM +0000, jf wrote: > > usually it's in: <PREFIX>/share/postgresql/contrib/pgcrypto.sql > > in the database you want to use pgcrypto functions, you simply run this > > sql (as superuser), and that's all. > theory# pwd > /home/jf/postgresql-8.2.4 > theory# cd share > bash: cd: share: No such file or directory > theory# pwd > /home/jf/postgresql-8.2.4 > theory# ls share > ls: cannot access share: No such file or directory share of *installed* system. if you compiled with --prefix=/usr/local, then it would be /usr/local/share/postgresql/... > theory# find ./ -name pgcrypto.sql > theory# cd contrib/pgcrypto/ > theory# ls *.sql if you didn't compile it - it is not built. simply: cd contrib/pgcrypto make make install and you should be fine. i usually compile postgresql in this way: cd postgre* ./configure --.... some options make make install cd contrib make make install in this way i have all contrib modules compiled. of course - you dont need all (on the other hand - i strongly suggest that you get some familiarity with it, as there are some real gems). depesz -- quicksil1er: "postgres is excellent, but like any DB it requires a highly paid DBA. here's my CV!" :) http://www.depesz.com/ - blog dla ciebie (i moje CV) ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
