MIME-Version: 1.0
References: <5EC17E17.7070002@anastigmatix.net>
 <CAASLQ4OdOma6h5Mu=hMEPyk0M4-MomYZLnhGH+2wVoL1vt_UEg@mail.gmail.com>
 <5ECED046.3000308@anastigmatix.net>
 <CAASLQ4P11FFgefy_xK0Tcw3vWt1F1MNyVgK5eU=PFGvYrpZcyw@mail.gmail.com>
 <5ED0FCB0.405@anastigmatix.net> <5ED10C6D.2020000@anastigmatix.net>
 <5ED10F36.7060304@anastigmatix.net>
 <CAASLQ4PAQ0PNAxJ5ad9U6o+RT2ip19FXvgoK2y1kGWaJbTZ1WQ@mail.gmail.com>
 <5ED15825.9060504@anastigmatix.net>
 <CAASLQ4OXAb+_J=oK54PH5eYuXjkV9KMsoXEcp-TYaQPqxk1Xbg@mail.gmail.com>
 <5ED270BA.9010001@anastigmatix.net> <5ED3D488.1010401@anastigmatix.net>
 <5ED474CA.3000106@anastigmatix.net>
 <CAASLQ4PfvmgKPp+aFf_r5RsBwigc+EC5Hm2CuzwJSTDCT64i-A@mail.gmail.com>
 <5ED4EA10.4030801@anastigmatix.net>
 <CAASLQ4Px21jyb2vJYSrjF5P0RqhA-G_DDWR9QHG68r+W+AqbxQ@mail.gmail.com>
 <CAASLQ4NYE-TW6hjbkSOuAY2Z4NM2cYzqSQ9ahO2LAUhdP9axeQ@mail.gmail.com>
 <5ED7E74B.9020800@anastigmatix.net>
 <CAASLQ4Od6-0=3+4ENKh1Z-Wcu5Wir-bwUn_ccO2UCmDhoR4vtQ@mail.gmail.com>
 <5EDA576E.2000204@anastigmatix.net>
In-Reply-To: <5EDA576E.2000204@anastigmatix.net>
From: Kartik Ohri <kartikohri13@gmail.com>
Date: Sat, 6 Jun 2020 18:10:26 +0530
Message-ID: 
 <CAASLQ4OzPwZB6GG_cXNW4WU4zpHa6wm8Q3WRWNv5pZpis+gf3w@mail.gmail.com>
Subject: Re: Starting build-system work (Windows/Mac users please speak up)
To: Chapman Flack <chap@anastigmatix.net>
Cc: pljava-dev@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000041ee7805a769afd1"
Precedence: bulk

--00000000000041ee7805a769afd1
Content-Type: text/plain; charset="UTF-8"

>
> or even to experiment with pg_ls_dir(), pg_stat_file(),
> pg_read_binary_file() [1] with the name of the JVM DLL or the directory
> it lives in, to see if PostgreSQL always gets "Access is denied".
>

I have played around a bit using your suggestions. It seems this is indeed
a permissions issue. The good thing is I was able to find a solution to it.

If this turns out to be a necessary step it will be good to get the
> details into the PL/Java documentation for Windows, because I'm
> pretty sure there's nothing about it in there now.
>

The solution is to use *pg_ctl* to start the postgres server from a shell
with appropriate permissions. Earlier, I was trying to start the postgres
server using *net start *in CMD and *Start-Service* in PowerShell. Even
with privileged shells, postgres created using these commands do not have
the necessary rights to some directories (including the Java directory,
hence, the libjvm location error). I was unable to figure out why this
happens.

I am now using pg_ctl to start the database. This is causing some issues in
the normal mode. The build stalls right after postgres starts. This does
not happen when the server is started using the other 2 options. I am
working on fixing this. However, in the interactive debug mode, I have been
able to use pg_ctl with success. I have run all the usual tests as on other
platforms except the -Xcheck:jni and all of these work.

Once this issue is fixed we will have a fully functional MSVC Windows
build. I'll let you know once this is done. Thanks.

--00000000000041ee7805a769afd1
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_quote"><blockquote class=3D"gmail_quot=
e" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204)=
;padding-left:1ex">or even to experiment with pg_ls_dir(), pg_stat_file(),<=
br>
pg_read_binary_file() [1] with the name of the JVM DLL or the directory<br>
it lives in, to see if PostgreSQL always gets &quot;Access is denied&quot;.=
<br></blockquote><div>=C2=A0</div><div>I have played around a bit using you=
r suggestions. It seems this is indeed a permissions issue. The good thing =
is I was able to find a solution to it.</div><div><br></div><blockquote cla=
ss=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid =
rgb(204,204,204);padding-left:1ex">
If this turns out to be a necessary step it will be good to get the<br>
details into the PL/Java documentation for Windows, because I&#39;m<br>
pretty sure there&#39;s nothing about it in there now.<br></blockquote><div=
><br></div><div>The solution is to use <b>pg_ctl</b> to start the postgres =
server from a shell with appropriate permissions. Earlier, I was trying to =
start the postgres server using <b>net start </b>in CMD and <b>Start-Servic=
e</b>=C2=A0in PowerShell. Even with privileged shells, postgres created usi=
ng these commands do not have the necessary rights to some directories (inc=
luding the Java=C2=A0directory, hence, the libjvm location error). I was un=
able to figure out why this happens.=C2=A0</div><div><br></div><div>I am no=
w using pg_ctl to start the database. This is causing some issues in the no=
rmal mode. The build stalls right after postgres starts. This does not happ=
en when the server is started using the other 2 options. I am working on fi=
xing this. However, in the interactive debug mode, I have been able to use =
pg_ctl with success. I have run all the usual tests as on other platforms e=
xcept the -Xcheck:jni and all of these work.=C2=A0</div><div><br></div><div=
>Once this issue is fixed we will have a fully functional MSVC Windows buil=
d. I&#39;ll let you know once this is done. Thanks.</div></div></div>

--00000000000041ee7805a769afd1--