pgcrypto and dblink

On Thu, Apr 10, 2008 at 3:46 PM, Roberts, Jon <Jon.Roberts@asurion.com> wrote:

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're not handled by 'configure'. They are in the 'contrib'
directory in the source tree, and you install them by first installing
PG itself, then go into the module directory, e.g. 'contrib/pgcrypto',
and running 'make'.

-Doug

Roberts, Jon escribió:

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.

Jon

They are contribs, you have to install them after pgsql

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're not handled by 'configure'. They are in the 'contrib'
directory in the source tree, and you install them by first installing
PG itself, then go into the module directory, e.g. 'contrib/pgcrypto',
and running 'make'.

Thanks so much!

Wouldn't it make sense to add a section to this page that describes the
contrib process?
http://www.postgresql.org/docs/8.3/static/install-post.html

I had thought all of the installation options were set using configure.
A post installation step is fine but I think it needs to be documented
as such.

Jon

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

On Thursday 10 April 2008 16:49, Roberts, Jon wrote:

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're not handled by 'configure'. They are in the 'contrib'
directory in the source tree, and you install them by first installing
PG itself, then go into the module directory, e.g. 'contrib/pgcrypto',
and running 'make'.

Thanks so much!

Wouldn't it make sense to add a section to this page that describes the
contrib process?
http://www.postgresql.org/docs/8.3/static/install-post.html

I had thought all of the installation options were set using configure.
A post installation step is fine but I think it needs to be documented
as such.

There are instructions on how to install them at
http://www.postgresql.org/docs/8.3/interactive/contrib.html, but your right
they don't seem to be mentioned anywhere in the install section. I'm not
sure where it should go, but perhaps making it 15.6.1 and bumping the other
items down a notch.

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL