From: Chris Browne <cbbrowne@acm.org>
Subject: Re: pgcrypto and dblink
Date: Thu, 10 Apr 2008 18:35:28 -0400
Organization: cbbrowne Computing Inc
Lines: 31
Message-ID: <60fxttxrrj.fsf@dba2.int.libertyrms.com>
References: 
 <1A6E6D554222284AB25ABE3229A92762E9A13B@nrtexcus702.int.asurion.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
User-Agent: Gnus/5.1008 (Gnus v5.10.8) XEmacs/21.4.21 (linux)
Cancel-Lock: sha1:MgighhfpZPj8t1Yy2sBQmlWYR9E=
To: pgsql-general@postgresql.org

Jon.Roberts@asurion.com ("Roberts, Jon") writes:
> I am moving from Windows to Solaris and I need pgcrypto and dblink.
> Where are these?  I don't see anything in the configure that suggests it
> is even an option.

They are part of the set of "contrib" functions.

You head to directory "contrib", and, if those are the only ones you
need, head assortedly to:

a) contrib/pgcrypto, and run "make install" to install that, then

b) contrib/dblink, and (surprise!) run "make install" to install it.

That compiles anything that needs to be compiled, and stows the object
code in the installation's "lib" area, and stows scripts to activate
the respective services in the installation's "share" area.

So step c) and d) would be...

c) Load, into whichever databases you want to use these functions in,
the script
   share/contrib/pgcrypto.sql

d) Load, into whichever databases you want to use these functions in,
the script
   share/contrib/dblink.sql
-- 
(reverse (concatenate 'string "ofni.secnanifxunil" "@" "enworbbc"))
http://cbbrowne.com/info/languages.html
Monday is an awful way to spend one seventh of your life.  -- Unknown