SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-11-2008, 12:53 AM
| ||||
| ||||
 pgcrypto and dblink 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general      |
|
04-11-2008, 12:53 AM
| |||
| |||
| Re: 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general |
|
04-11-2008, 12:53 AM
| |||
| |||
| Re: pgcrypto and dblink > > 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/s...tall-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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general |
|
04-11-2008, 12:53 AM
| ||||
| ||||
| Re: pgcrypto and dblink 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 |
Linear Mode
