Postgres Pro
Downloads
Home   >   mailing lists

Thread: Configuration Question

Configuration Question

From
Terry Lee Tucker
Date:
Greetings:

Is there a way to get hold of an environment variable such that it can be
referenced in postgresql.conf? In particular, I'd like to be able to point
dynamic_library_path to an environment variable defined at the system level
as in dynamic_library_path = '$SOURCE:$libdir'.

master=# select version();
                                                version
--------------------------------------------------------------------------------------------------------
 PostgreSQL 8.3.3 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.2
20070626 (Red Hat 4.1.2-14)

TIA
--

Re: Configuration Question

From
Martin Gainty
Date:
v8.3 FAQ_Solaris

To point it to the right location, set the
LD_LIBRARY_PATH environment variable, e.g.,

    LD_LIBRARY_PATH=/usr/sfw/lib:/opt/sfw/lib:/usr/local/lib
    export LD_LIBRARY_PATH

and restart configure.  You will also have to keep this setting whenever
you run any of the installed PostgreSQL programs.   Alternatively, set
the environment variable LD_RUN_PATH.  See the ld(1) man page for more
information.

either LD_LIBRARY_PATH or LD_RUN_PATH should contain binary folder
Martin Gainty
______________________________________________
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
 
Ez az üzenet bizalmas.  Ha nem ön az akinek szánva volt, akkor kérjük, hogy jelentse azt nekünk vissza. Semmiféle továbbítása vagy másolatának készítése nem megengedett.  Ez az üzenet csak ismeret cserét szolgál és semmiféle jogi alkalmazhatósága sincs.  Mivel az electronikus üzenetek könnyen megváltoztathatóak, ezért minket semmi felelöség nem terhelhet ezen üzenet tartalma miatt.

Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni.





> From: terry@chosen-ones.org
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Configuration Question
> Date: Tue, 18 Aug 2009 06:32:25 -0400
>
> Greetings:
>
> Is there a way to get hold of an environment variable such that it can be
> referenced in postgresql.conf? In particular, I'd like to be able to point
> dynamic_library_path to an environment variable defined at the system level
> as in dynamic_library_path = '$SOURCE:$libdir'.
>
> master=# select version();
> version
> --------------------------------------------------------------------------------------------------------
> PostgreSQL 8.3.3 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.2
> 20070626 (Red Hat 4.1.2-14)
>
> TIA
> --
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

Windows Live: Keep your friends up to date with what you do online. Find out more.

Re: Configuration Question

From
Terry Lee Tucker
Date:
On Tuesday 18 August 2009 09:28, Martin Gainty wrote:
> v8.3 FAQ_Solaris
>
> To point it to the right location, set the
> LD_LIBRARY_PATH environment variable, e.g.,
>
>     LD_LIBRARY_PATH=/usr/sfw/lib:/opt/sfw/lib:/usr/local/lib
>     export LD_LIBRARY_PATH
>
> and restart configure.  You will also have to keep this setting whenever
> you run any of the installed PostgreSQL programs.   Alternatively, set
> the environment variable LD_RUN_PATH.  See the ld(1) man page for more
> information.
>
> either LD_LIBRARY_PATH or LD_RUN_PATH should contain binary folder
> Martin Gainty
>

OK. Thanks for the help. I'll give this a try.

> > From: terry@chosen-ones.org
> > To: pgsql-general@postgresql.org
> > Subject: [GENERAL] Configuration Question
> > Date: Tue, 18 Aug 2009 06:32:25 -0400
> >
> > Greetings:
> >
> > Is there a way to get hold of an environment variable such that it can be
> > referenced in postgresql.conf? In particular, I'd like to be able to
> > point dynamic_library_path to an environment variable defined at the
> > system level as in dynamic_library_path = '$SOURCE:$libdir'.
> >
> > master=# select version();
> >                                                 version
> > -------------------------------------------------------------------------
> >------------------------------- PostgreSQL 8.3.3 on i686-redhat-linux-gnu,
> > compiled by GCC gcc (GCC) 4.1.2 20070626 (Red Hat 4.1.2-14)
> >
> > TIA
> > --
> >
> > --
> > Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsql-general
>
> _________________________________________________________________
> Windows Live: Keep your friends up to date with what you do online.
> http://windowslive.com/Campaign/SocialNetworking?ocid=PID23285::T:WLMTAGL:O
>N:WL:en-US:SI_SB_online:082009

--

Re: Configuration Question

From
Tom Lane
Date:
Terry Lee Tucker <terry@chosen-ones.org> writes:
> Is there a way to get hold of an environment variable such that it can be
> referenced in postgresql.conf?

No, but you could perhaps set that GUC on the postmaster command line
instead.

    postmaster ... --dynamic_library_path="$SOURCE:$$libdir"

            regards, tom lane