Search Postgresql Archives

Re: How best to load modules?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

Here is the best cludge so far.  To load the module 'tablefunc' from the
contrib/ directory, process the output of the 'pg_config' program with unix
commands.  The 'pg_config' program is often distributed in a package
separate from  postgresql.

\set tablefunc `pg_config|grep SHAREDIR|sed "s/SHAREDIR = \(.*\)/\1\/contrib\/tablefunc.sql/g"`
\i :tablefunc

This isn't very robust, but at least it allows me to load and unload stuff
from a single sql script on two different distros.

Cheers!


On 28.01.11, Steve White wrote:
> Hello, all!
> 
> What are best practices regarding the loading of postgresql modules, say
> from the contrib/ directory; specifically, with regard to portability?
> 
> I would like to distribute an SQL script which loads a module, and works
> with as little further fiddling as possible.
> 
> known options
> =============
> 
> Within a session, or in a script, one can use 
> 	\i <explicit file path>
> But within a script this has the weakness that the file path varies from
> one system distribution to another.
> 
> One can start psql with 
> 	psql ... -f <explicit file path>
> but that's a measure taken outside the script, to done either with session,
> or else be done by a further measure such as a shell script.
> 
> Ideally, the location of the default modules directory (or installation
> directory) should be available within a session in some variable or from
> some function call.
> 
> There are some pre-defined variables, listed in a session by
> 	show all;
> but I don't see anything like a directory path there.
> Maybe a built-in function returning this directory?  Searched to no avail:
> 	http://www.postgresql.org/docs/8.2/interactive/functions.html
> 
> There has been talk about a bigger solution on
> 	http://wiki.postgresql.org/wiki/Module_Manager
> but little seems to have happened there in some years.
> 
> An environment variable
> 	$libdir, 
> is mentioned
> 	http://www.postgresql.org/docs/8.2/static/runtime-config-client.html
> but this seems not to be present within a session.
> It seems to be expanded within the LANGUAGE C environment, for instance in
> tablefunc.sql
>  -------------------------------------------------
> CREATE OR REPLACE FUNCTION crosstab2(text)
> RETURNS setof tablefunc_crosstab_2
> AS '$libdir/tablefunc','crosstab'
> LANGUAGE C STABLE STRICT;
>  -------------------------------------------------
> 
> Thanks!
> 
> -- 
> | -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -
> | Steve White                                             +49(331)7499-202
> | E-Science                                        Zi. 27  Villa Turbulenz 
> | -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -
> | Astrophysikalisches Institut Potsdam (AIP)
> | An der Sternwarte 16, D-14482 Potsdam
> |
> | Vorstand: Prof. Dr. Matthias Steinmetz, Peter A. Stolz
> |
> | Stiftung privaten Rechts, Stiftungsverzeichnis Brandenburg: III/7-71-026
> | -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -

-- 
| -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -
| Steve White                                             +49(331)7499-202
| E-Science                                        Zi. 27  Villa Turbulenz 
| -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -
| Astrophysikalisches Institut Potsdam (AIP)
| An der Sternwarte 16, D-14482 Potsdam
|
| Vorstand: Prof. Dr. Matthias Steinmetz, Peter A. Stolz
|
| Stiftung privaten Rechts, Stiftungsverzeichnis Brandenburg: III/7-71-026
| -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux