Configuration Question
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
--
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 -0400Greetings:
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:ON:WL:en-US:SI_SB_online:082009
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_PATHand 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 -0400Greetings:
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
--
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