[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] PROJ_LIB environment variable
From: "Regina Obe" <lr () pcorp ! us>
Date: 2021-11-19 4:08:56
Message-ID: 000001d7dcfb$2ca323b0$85e96b10$ () pcorp ! us
[Download RAW message or body]
This is a multipart message in MIME format.
[Attachment #2 (multipart/related)]
This is a multipart message in MIME format.
[Attachment #4 (multipart/alternative)]
Regarding the environment variables, I think if you define it during the
service install process, whatever variables are defined locally will
override the global ones. I think that is how installation of PostgreSQL
sets up different postgresql bin/lib paths as you can see in the installed
pg_env.bat
Another way to do it is just run them under different service accounts and
have the env variables defined at the user level for that account instead of
system. I think user variables override the system ones if they are
defined in both places.
As part of packaging I do try to keep all the dependencies the same of
PostGIS for all versions of PostgreSQL at least for same PostGIS version to
minimize on these issues. So as long as you are running the same version of
PostGIS on all versions of PostgreSQL you should be fine.
Thanks,
Regina
From: postgis-users [mailto:postgis-users-bounces@lists.osgeo.org] On Behalf
Of Wisse J.S. (Jeroen)
Sent: Thursday, November 18, 2021 8:37 AM
To: 'PostGIS Users Discussion' <postgis-users@lists.osgeo.org>
Subject: Re: [postgis-users] PROJ_LIB environment variable
Thank you for your help Regina,
Wouldn't your solution just override the environmental variable?
Anyway I just looked into it further and it seems to be a non-issue for us.
I compared the 2 different PROJ_LIB directories and they are exactly the
same. All the files in there are exactly the same as well.
So it doesn't matter where the variable points to.
Thanks again for the help,
Jeroen
Van: postgis-users <postgis-users-bounces@lists.osgeo.org
<mailto:postgis-users-bounces@lists.osgeo.org> > Namens Regina Obe
Verzonden: donderdag 18 november 2021 14:15
Aan: 'PostGIS Users Discussion' <postgis-users@lists.osgeo.org
<mailto:postgis-users@lists.osgeo.org> >
Onderwerp: Re: [postgis-users] PROJ_LIB environment variable
One note I think if you set the variables before PostgreSQL is installed as
a service it will set it on use.
Take a look at C:\Program Files\PostgreSQL\14\pg_env.bat
I've never tried it before though, but it's my understanding it reads that
file during installation. And registration of the service. So I suspect if
you edit that file adding the PROJ_LIB path and then reinstall or manually
register the service it should work.
For my testing I have a script that has all these envs in it and then starts
up PostgreSQL so I can easily control which version of everything I am
using.
Hope that helps,
Regina
From: Regina Obe [mailto:lr@pcorp.us]
Sent: Thursday, November 18, 2021 8:06 AM
To: 'PostGIS Users Discussion' <postgis-users@lists.osgeo.org
<mailto:postgis-users@lists.osgeo.org> >
Subject: RE: [postgis-users] PROJ_LIB environment variable
From: postgis-users [mailto:postgis-users-bounces@lists.osgeo.org] On Behalf
Of Wisse J.S. (Jeroen)
Sent: Wednesday, November 17, 2021 8:45 AM
To: 'postgis-users@lists.osgeo.org' <postgis-users@lists.osgeo.org
<mailto:postgis-users@lists.osgeo.org> >
Subject: [postgis-users] PROJ_LIB environment variable
Hi,
We have a server that has multiple versions of PostgreSQL installed.
Some of these PostgreSQL installations use the PostGIS extension.
Unfortunately these PostGIS extensions are all different versions.
When using the windows installer for PostGIS some environment variables are
set. Some can have the same value for each PostGIS installation. But there
are 2 that refer to a specific directory.
These are:
- GDAL_DATA: which also can be set in the postgresql.conf file as
postgis.gdal_datapath
- PROJ_LIB
My question is, is it possible to set the PROJ_LIB variable somewhere else
then as an environment variable?
Kind regards,
Jeroen Wisse
[Regina Obe]
Not to my knowledge, but I'd be happy to be proven wrong.
That said which versions of proj are you using? It should only be used for
Pro > 6
Pre-Proj 6.0 this setting wasn't important and I never used it. PostGIS
always looked for all it needed in the contrib/postgis*/proj folder
[Attachment #7 (text/html)]
<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type \
content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 15 \
(filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);} o\:* \
{behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Arial",sans-serif;
color:windowtext;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle22
{mso-style-type:personal;
font-family:"Arial",sans-serif;
color:#44546A;}
span.EmailStyle23
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1298415747;
mso-list-type:hybrid;
mso-list-template-ids:-1380149806 160991684 68354051 68354053 68354049 68354051 \
68354053 68354049 68354051 68354053;} @list l0:level1
{mso-level-start-at:0;
mso-level-number-format:bullet;
mso-level-text:-;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Arial",sans-serif;
mso-fareast-font-family:Calibri;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link="#0563C1" \
vlink="#954F72"><div class=WordSection1><p class=MsoNormal><span \
style='color:#1F497D'>Regarding the environment variables, I think if you define it \
during the service install process, whatever variables are defined locally will \
override the global ones. I think that is how installation of PostgreSQL sets \
up different postgresql bin/lib paths as you can see in the installed \
pg_env.bat<o:p></o:p></span></p><p class=MsoNormal><span \
style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span \
style='color:#1F497D'>Another way to do it is just run them under different service \
accounts and have the env variables defined at the user level for that account \
instead of system. I think user variables override the system ones if \
they are defined in both places.<o:p></o:p></span></p><p class=MsoNormal><img \
width=329 height=303 id="Picture_x0020_1" \
src="cid:image001.jpg@01D7DCD1.4313DDD0"><span \
style='color:#1F497D'><o:p></o:p></span></p><p class=MsoNormal><span \
style='color:#1F497D'>As part of packaging I do try to keep all the dependencies the \
same of PostGIS for all versions of PostgreSQL at least for same PostGIS version to \
minimize on these issues. So as long as you are running the same version of PostGIS \
on all versions of PostgreSQL you should be fine.<o:p></o:p></span></p><p \
class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p \
class=MsoNormal><span style='color:#1F497D'>Thanks,<o:p></o:p></span></p><p \
class=MsoNormal><span style='color:#1F497D'>Regina<o:p></o:p></span></p><p \
class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div \
style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'><div><div \
style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p \
class=MsoNormal><b>From:</b> postgis-users \
[mailto:postgis-users-bounces@lists.osgeo.org] <b>On Behalf Of </b>Wisse J.S. \
(Jeroen)<br><b>Sent:</b> Thursday, November 18, 2021 8:37 AM<br><b>To:</b> 'PostGIS \
Users Discussion' <postgis-users@lists.osgeo.org><br><b>Subject:</b> Re: \
[postgis-users] PROJ_LIB environment variable<o:p></o:p></p></div></div><p \
class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span \
style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#44546A'>Thank you for \
your help Regina,<o:p></o:p></span></p><p class=MsoNormal><span \
style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#44546A'>Wouldn’t \
your solution just override the environmental variable?<o:p></o:p></span></p><p \
class=MsoNormal><span \
style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#44546A'><o:p> </o:p></span></p><p \
class=MsoNormal><span \
style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#44546A'>Anyway I just \
looked into it further and it seems to be a non-issue for us.<o:p></o:p></span></p><p \
class=MsoNormal><span \
style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#44546A'>I compared the \
2 different PROJ_LIB directories and they are exactly the same. All the files in \
there are exactly the same as well.<o:p></o:p></span></p><p class=MsoNormal><span \
style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#44546A'><o:p> </o:p></span></p><p \
class=MsoNormal><span \
style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#44546A'>So it \
doesn’t matter where the variable points to.<o:p></o:p></span></p><p \
class=MsoNormal><span \
style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#44546A'><o:p> </o:p></span></p><p \
class=MsoNormal><span \
style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#44546A'>Thanks again \
for the help,<o:p></o:p></span></p><p class=MsoNormal><span \
style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#44546A'><o:p> </o:p></span></p><p \
class=MsoNormal><span \
style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#44546A'>Jeroen<o:p></o:p></span></p><div><div \
style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p \
class=MsoNormal><b>Van:</b> postgis-users <<a \
href="mailto:postgis-users-bounces@lists.osgeo.org">postgis-users-bounces@lists.osgeo.org</a>> \
<b>Namens </b>Regina Obe<br><b>Verzonden:</b> donderdag 18 november 2021 \
14:15<br><b>Aan:</b> 'PostGIS Users Discussion' <<a \
href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>><br><b>Onderwerp:</b> \
Re: [postgis-users] PROJ_LIB environment variable<o:p></o:p></p></div></div><p \
class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span \
style='color:#1F497D'>One note I think if you set the variables before PostgreSQL is \
installed as a service it will set it on use.<o:p></o:p></span></p><p \
class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p \
class=MsoNormal><span style='color:#1F497D'>Take a look at C:\Program \
Files\PostgreSQL\14\pg_env.bat<o:p></o:p></span></p><p class=MsoNormal><span \
style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span \
style='color:#1F497D'>I’ve never tried it before though, but it’s my \
understanding it reads that file during installation. And registration of the \
service. So I suspect if you edit that file adding the PROJ_LIB path and then \
reinstall or manually register the service it should work.<o:p></o:p></span></p><p \
class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p \
class=MsoNormal><span style='color:#1F497D'>For my testing I have a script that has \
all these envs in it and then starts up PostgreSQL so I can easily control which \
version of everything I am using.<o:p></o:p></span></p><p class=MsoNormal><span \
style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span \
style='color:#1F497D'>Hope that helps,<o:p></o:p></span></p><p class=MsoNormal><span \
style='color:#1F497D'>Regina<o:p></o:p></span></p><p class=MsoNormal><span \
style='color:#1F497D'><o:p> </o:p></span></p><div \
style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'><div><div \
style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p \
class=MsoNormal><b>From:</b> Regina Obe [<a \
href="mailto:lr@pcorp.us">mailto:lr@pcorp.us</a>] <br><b>Sent:</b> Thursday, November \
18, 2021 8:06 AM<br><b>To:</b> 'PostGIS Users Discussion' <<a \
href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>><br><b>Subject:</b> \
RE: [postgis-users] PROJ_LIB environment variable<o:p></o:p></p></div></div><p \
class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span \
style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span \
style='color:#1F497D'><o:p> </o:p></span></p><div \
style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'><div><div \
style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p \
class=MsoNormal><b>From:</b> postgis-users [<a \
href="mailto:postgis-users-bounces@lists.osgeo.org">mailto:postgis-users-bounces@lists.osgeo.org</a>] \
<b>On Behalf Of </b>Wisse J.S. (Jeroen)<br><b>Sent:</b> Wednesday, November 17, 2021 \
8:45 AM<br><b>To:</b> 'postgis-users@lists.osgeo.org' <<a \
href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>><br><b>Subject:</b> \
[postgis-users] PROJ_LIB environment variable<o:p></o:p></p></div></div><p \
class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span \
style='font-size:10.0pt;font-family:"Arial",sans-serif'>Hi,<o:p></o:p></span></p><p \
class=MsoNormal><span \
style='font-size:10.0pt;font-family:"Arial",sans-serif'><o:p> </o:p></span></p><p \
class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial",sans-serif'>We have \
a server that has multiple versions of PostgreSQL installed.<o:p></o:p></span></p><p \
class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial",sans-serif'>Some of \
these PostgreSQL installations use the PostGIS extension. Unfortunately these PostGIS \
extensions are all different versions.<o:p></o:p></span></p><p class=MsoNormal><span \
style='font-size:10.0pt;font-family:"Arial",sans-serif'><o:p> </o:p></span></p><p \
class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial",sans-serif'>When \
using the windows installer for PostGIS some environment variables are set. Some can \
have the same value for each PostGIS installation. But there are 2 that refer to a \
specific directory.<o:p></o:p></span></p><p class=MsoNormal><span \
style='font-size:10.0pt;font-family:"Arial",sans-serif'>These \
are:<o:p></o:p></span></p><p class=MsoNormal><span \
style='font-size:10.0pt;font-family:"Arial",sans-serif'><o:p> </o:p></span></p><p \
class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo2'><![if \
!supportLists]><span style='font-size:10.0pt;font-family:"Arial",sans-serif'><span \
style='mso-list:Ignore'>-<span style='font:7.0pt "Times New \
Roman"'> </span></span></span><![endif]><span \
style='font-size:10.0pt;font-family:"Arial",sans-serif'>GDAL_DATA: which also can be \
set in the postgresql.conf file as postgis.gdal_datapath<o:p></o:p></span></p><p \
class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo2'><![if \
!supportLists]><span style='font-size:10.0pt;font-family:"Arial",sans-serif'><span \
style='mso-list:Ignore'>-<span style='font:7.0pt "Times New \
Roman"'> </span></span></span><![endif]><span \
style='font-size:10.0pt;font-family:"Arial",sans-serif'>PROJ_LIB<o:p></o:p></span></p><p \
class=MsoNormal><span \
style='font-size:10.0pt;font-family:"Arial",sans-serif'><o:p> </o:p></span></p><p \
class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial",sans-serif'>My \
question is, is it possible to set the PROJ_LIB variable somewhere else then as an \
environment variable?<o:p></o:p></span></p><p class=MsoNormal><span \
style='font-size:10.0pt;font-family:"Arial",sans-serif'><o:p> </o:p></span></p><p \
class=MsoNormal><span \
style='font-size:10.0pt;font-family:"Arial",sans-serif'><o:p> </o:p></span></p><p \
class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial",sans-serif'>Kind \
regards,<o:p></o:p></span></p><p class=MsoNormal><span \
style='font-size:10.0pt;font-family:"Arial",sans-serif'><o:p> </o:p></span></p><p \
class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial",sans-serif'>Jeroen \
Wisse<o:p></o:p></span></p><p class=MsoNormal><b><i><span \
style='color:#1F497D'>[Regina Obe] <o:p></o:p></span></i></b></p><p \
class=MsoNormal><b><i><span style='color:#1F497D'>Not to my knowledge, but I’d \
be happy to be proven wrong.<o:p></o:p></span></i></b></p><p \
class=MsoNormal><b><i><span style='color:#1F497D'>That said which versions of proj \
are you using? It should only be used for Pro > 6<o:p></o:p></span></i></b></p><p \
class=MsoNormal><b><i><span \
style='color:#1F497D'><o:p> </o:p></span></i></b></p><p \
class=MsoNormal><b><i><span style='color:#1F497D'>Pre-Proj 6.0 this setting \
wasn’t important and I never used it. PostGIS always looked for all it needed \
in the contrib/postgis*/proj folder</span></i></b><span \
style='color:#1F497D'><o:p></o:p></span></p></div></div></div></div></body></html>
["image001.jpg" (image/jpeg)]
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic