Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jhCeO-0005lr-Nn for pljava-dev@arkaria.postgresql.org; Fri, 05 Jun 2020 13:44:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jhCeN-0006ta-CV for pljava-dev@arkaria.postgresql.org; Fri, 05 Jun 2020 13:44:47 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jhCeN-0006tT-0X for pljava-dev@lists.postgresql.org; Fri, 05 Jun 2020 13:44:47 +0000 Received: from mail-ej1-x641.google.com ([2a00:1450:4864:20::641]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jhCeG-0004YY-Ed for pljava-dev@lists.postgresql.org; Fri, 05 Jun 2020 13:44:45 +0000 Received: by mail-ej1-x641.google.com with SMTP id l12so6405582ejn.10 for ; Fri, 05 Jun 2020 06:44:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=oxOX99jEU7VUGsh5my7qg2Mh5/e4k8E0Bxsqzyl56Ic=; b=U5JRfQTl3HEKmdVXa1m8G/m2Q8qgEITap8tVV9FOGchMlQbH17DjH62ZH31UPfCG+Z unD2efopt5t+Nk1gpl9EfX5BpP/i63utU6nIQDm2CBvRG3G2SB54jdV7s3Dou1CmRynU pb8bsRoP4nsIQf0XWHsNBlVzh1SR6aj4yNKfgAIM626rBz4geX96bZ5pPp7FTmXNHrdC b7ITqM1MD1wWYoRT6yx8DSZpAZnQ5oAri7dDOZDNcXfHTGxkmeV9Pq7cl2AQYJnopLi0 WXlJcc5eOTYL7vGxoLqWTugGZgdaas/jBjdYKtOWTeSr0nnRVdQgZ8OQYmmjuAqKN/I3 910g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=oxOX99jEU7VUGsh5my7qg2Mh5/e4k8E0Bxsqzyl56Ic=; b=cODdyeglekcMngG0LAeytSfdVA5kVQO+PZFGmf/3piW8kPL4ZgPcVlX2lIATkf3GS0 uaMrAbIg+OZDabJMxSXr2ZxNJ/1gOhNO+H5dpgfvsk58ozsVYQ5YTtjg8E+vr3SAUQ6U XUTH/r/Bz9rffAadkdlKrGbvNC/mB5IsKqWtYAA5Wiztx4BIO0bQMEz6reR0v6cXnwyS XkYY7/m7iVSKe9AC0f5hlPERvboVsB9AxaxuexiF63oz5QpDr9OAzuKWy3AS1e40Sk0O pUGb/iqOlCflDgeHLXmZAetQ1VmqHHMu3kqBeoQAzgSIUV79iv9UUQ/J0gAcrl1VHHRi Mciw== X-Gm-Message-State: AOAM532aGSE4MjkQhmgcjFs1RAGnSpP2OXsf9FZ4NIstA2NF6IPNlU2S wxnVKM0S+TEof0uYgAi4xYVZQvOQdGRI5FEqtQB+yNJ/9V5/Ew== X-Google-Smtp-Source: ABdhPJyUpepgRvp/rp6+aSf52ExZzJ/1bw7MJt64uMg1Q32Jxj7UCt/pS1V7t+C8gUH/HJWVNmZA0s6DRSJtQI0KVHc= X-Received: by 2002:a17:906:5410:: with SMTP id q16mr9052077ejo.103.1591364677959; Fri, 05 Jun 2020 06:44:37 -0700 (PDT) MIME-Version: 1.0 References: <5EC17E17.7070002@anastigmatix.net> <5ECED046.3000308@anastigmatix.net> <5ED0FCB0.405@anastigmatix.net> <5ED10C6D.2020000@anastigmatix.net> <5ED10F36.7060304@anastigmatix.net> <5ED15825.9060504@anastigmatix.net> <5ED270BA.9010001@anastigmatix.net> <5ED3D488.1010401@anastigmatix.net> <5ED474CA.3000106@anastigmatix.net> <5ED4EA10.4030801@anastigmatix.net> <5ED7E74B.9020800@anastigmatix.net> In-Reply-To: <5ED7E74B.9020800@anastigmatix.net> From: Kartik Ohri Date: Fri, 5 Jun 2020 19:14:25 +0530 Message-ID: Subject: Re: Starting build-system work (Windows/Mac users please speak up) To: Chapman Flack Cc: pljava-dev@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000005682b505a7567657" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --0000000000005682b505a7567657 Content-Type: text/plain; charset="UTF-8" Hi! I think ALTER USER will do the job but I am again facing an issue with the pljava.libjvm_location. This works fine on Linux and macOS but not on Windows. I have tried escaping the / and used \ as well but none seems to be working. Here are the pljava variables. select name, source, setting from pg_settings where name like 'pljava.%'; name | source | setting ----------------------------------------------+---------+------------------------------------------------------------------------------------------------------------------------------------------------- pljava.debug | default | off pljava.enable | default | on pljava.implementors | default | postgresql pljava.java_thread_pg_entry | default | allow pljava.libjvm_location | session | C:/Program Files/Java/jdk14/bin/server/jvm.dll pljava.module_path | default | C:/Program Files/PostgreSQL/12/share/pljava/pljava-1.6.0-SNAPSHOT.jar;C:/Program Files/PostgreSQL/12/share/pljava/pljava-api-1.6.0-SNAPSHOT.jar pljava.release_lingering_savepoints | default | off pljava.statement_cache_size | default | 11 pljava.vmoptions | default | And here is the psql log, 2020-06-05 13:25:06.558 UTC [5652] LOG: database system was shut down at 2020-05-27 01:18:49 UTC 2020-06-05 13:25:06.585 UTC [1056] LOG: database system is ready to accept connections 2020-06-05 13:27:20.207 UTC [1056] LOG: received SIGHUP, reloading configuration files 2020-06-05 13:27:20.385 UTC [3096] WARNING: Java virtual machine not yet loaded 2020-06-05 13:27:20.385 UTC [3096] DETAIL: Access is denied. 2020-06-05 13:27:20.385 UTC [3096] HINT: SET pljava.libjvm_location TO the correct path to the jvm library (libjvm.so or jvm.dll, etc.) 2020-06-05 13:27:20.395 UTC [3096] ERROR: cannot use PL/Java before successfully completing its setup 2020-06-05 13:27:20.395 UTC [3096] HINT: Check the log for messages closely preceding this one, detailing what step of setup failed and what will be needed, probably setting one of the "pljava." configuration variables, to complete the setup. If there is not enough help in the log, try again with different settings for "log_min_messages" or "log_error_verbosity". 2020-06-05 13:27:20.395 UTC [3096] STATEMENT: CREATE EXTENSION pljava; 2020-06-05 13:36:27.036 UTC [5152] ERROR: unrecognized configuration parameter "client_min_messgaes" 2020-06-05 13:36:27.036 UTC [5152] STATEMENT: set client_min_messgaes to DEBUG1; 2020-06-05 13:36:32.400 UTC [5152] ERROR: unrecognized configuration parameter "client_min_messgages" 2020-06-05 13:36:32.400 UTC [5152] STATEMENT: set client_min_messgages to DEBUG1; 2020-06-05 13:37:58.758 UTC [5152] WARNING: Java virtual machine not yet loaded 2020-06-05 13:37:58.758 UTC [5152] DETAIL: Access is denied. 2020-06-05 13:37:58.758 UTC [5152] HINT: SET pljava.libjvm_location TO the correct path to the jvm library (libjvm.so or jvm.dll, etc.) 2020-06-05 13:37:58.762 UTC [5152] ERROR: cannot use PL/Java before successfully completing its setup 2020-06-05 13:37:58.762 UTC [5152] HINT: Check the log for messages closely preceding this one, detailing what step of setup failed and what will be needed, probably setting one of the "pljava." configuration variables, to complete the setup. If there is not enough help in the log, try again with different settings for "log_min_messages" or "log_error_verbosity". 2020-06-05 13:37:58.762 UTC [5152] STATEMENT: CREATE EXTENSION pljava; 2020-06-05 13:38:50.100 UTC [5152] WARNING: Java virtual machine not yet loaded 2020-06-05 13:38:50.100 UTC [5152] DETAIL: Access is denied. 2020-06-05 13:38:50.100 UTC [5152] HINT: SET pljava.libjvm_location TO the correct path to the jvm library (libjvm.so or jvm.dll, etc.) 2020-06-05 13:39:26.369 UTC [5152] WARNING: Java virtual machine not yet loaded 2020-06-05 13:39:26.369 UTC [5152] DETAIL: Access is denied. 2020-06-05 13:39:26.369 UTC [5152] HINT: SET pljava.libjvm_location TO the correct path to the jvm library (libjvm.so or jvm.dll, etc.) 2020-06-05 13:39:26.374 UTC [5152] ERROR: cannot use PL/Java before successfully completing its setup 2020-06-05 13:39:26.374 UTC [5152] HINT: Check the log for messages closely preceding this one, detailing what step of setup failed and what will be needed, probably setting one of the "pljava." configuration variables, to complete the setup. If there is not enough help in the log, try again with different settings for "log_min_messages" or "log_error_verbosity". I hope you can shed some light on this. --0000000000005682b505a7567657 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi! I think ALTER USER will do the job but I am again faci= ng an issue with the pljava.libjvm_location. This works fine on Linux and m= acOS but not on Windows.=C2=A0 I have tried escaping the / and used \ as we= ll but none seems to be working.=C2=A0

Here are the pljava var= iables.

select name, source, setting from pg_setti= ngs where name like 'pljava.%';
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 name=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | source =C2=A0= | =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 setting =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0
----------------------------------------------+= ---------+-----------------------------------------------------------------= ---------------------------------------------------------------------------= -----
=C2=A0pljava.debug=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | de= fault | off
=C2=A0pljava.enable=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0| default | on
=C2=A0pljava.implementors=C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | default | postgresql
= =C2=A0pljava.java_thread_pg_entry =C2=A0 =C2=A0 =C2=A0 =C2=A0 | default | a= llow
=C2=A0pljava.libjvm_location=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | session | C:/Program Files/Java/jdk14/bin= /server/jvm.dll
=C2=A0pljava.module_path=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| default | C:/Program = Files/PostgreSQL/12/share/pljava/pljava-1.6.0-SNAPSHOT.jar;C:/Program Files= /PostgreSQL/12/share/pljava/pljava-api-1.6.0-SNAPSHOT.jar
=C2=A0pljava.r= elease_lingering_savepoints | default | off
=C2=A0pljava.statement_cache= _size=C2=A0 =C2=A0 =C2=A0 =C2=A0 | default | 11
=C2=A0pljava.vmoptions= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0| default |

And here is th= e psql log,

2020-06-05 13:25:06.558 UTC [5652] LOG= : =C2=A0database system was shut down at 2020-05-27 01:18:49 UTC
2020-06= -05 13:25:06.585 UTC [1056] LOG: =C2=A0database system is ready to accept c= onnections
2020-06-05 13:27:20.207 UTC [1056] LOG: =C2=A0received SIGHUP= , reloading configuration files
2020-06-05 13:27:20.385 UTC [3096] WARNI= NG: =C2=A0Java virtual machine not yet loaded
2020-06-05 13:27:20.385 UT= C [3096] DETAIL: =C2=A0Access is denied.


2020-06-05 13:27:20.385= UTC [3096] HINT: =C2=A0SET pljava.libjvm_location TO the correct path to t= he jvm library (libjvm.so or jvm.dll, etc.)
2020-06-05 13:27:20.395 UTC = [3096] ERROR: =C2=A0cannot use PL/Java before successfully completing its s= etup
2020-06-05 13:27:20.395 UTC [3096] HINT: =C2=A0Check the log for me= ssages closely preceding this one, detailing what step of setup failed and = what will be needed, probably setting one of the "pljava." config= uration variables, to complete the setup. If there is not enough help in th= e log, try again with different settings for "log_min_messages" o= r "log_error_verbosity".
2020-06-05 13:27:20.395 UTC [3096] ST= ATEMENT: =C2=A0CREATE EXTENSION pljava;
2020-06-05 13:36:27.036 UTC [515= 2] ERROR: =C2=A0unrecognized configuration parameter "client_min_messg= aes"
2020-06-05 13:36:27.036 UTC [5152] STATEMENT: =C2=A0set client= _min_messgaes to DEBUG1;
2020-06-05 13:36:32.400 UTC [5152] ERROR: =C2= =A0unrecognized configuration parameter "client_min_messgages"2020-06-05 13:36:32.400 UTC [5152] STATEMENT: =C2=A0set client_min_messgag= es to DEBUG1;
2020-06-05 13:37:58.758 UTC [5152] WARNING: =C2=A0Java vir= tual machine not yet loaded
2020-06-05 13:37:58.758 UTC [5152] DETAIL: = =C2=A0Access is denied.


2020-06-05 13:37:58.758 UTC [5152] HINT:= =C2=A0SET pljava.libjvm_location TO the correct path to the jvm library (l= ibjvm.so or jvm.dll, etc.)
2020-06-05 13:37:58.762 UTC [5152] ERROR: =C2= =A0cannot use PL/Java before successfully completing its setup
2020-06-0= 5 13:37:58.762 UTC [5152] HINT: =C2=A0Check the log for messages closely pr= eceding this one, detailing what step of setup failed and what will be need= ed, probably setting one of the "pljava." configuration variables= , to complete the setup. If there is not enough help in the log, try again = with different settings for "log_min_messages" or "log_error= _verbosity".
2020-06-05 13:37:58.762 UTC [5152] STATEMENT: =C2=A0CR= EATE EXTENSION pljava;
2020-06-05 13:38:50.100 UTC [5152] WARNING: =C2= =A0Java virtual machine not yet loaded
2020-06-05 13:38:50.100 UTC [5152= ] DETAIL: =C2=A0Access is denied.


2020-06-05 13:38:50.100 UTC [5= 152] HINT: =C2=A0SET pljava.libjvm_location TO the correct path to the jvm = library (libjvm.so or jvm.dll, etc.)
2020-06-05 13:39:26.369 UTC [5152] = WARNING: =C2=A0Java virtual machine not yet loaded
2020-06-05 13:39:26.3= 69 UTC [5152] DETAIL: =C2=A0Access is denied.


2020-06-05 13:39:2= 6.369 UTC [5152] HINT: =C2=A0SET pljava.libjvm_location TO the correct path= to the jvm library (libjvm.so or jvm.dll, etc.)
2020-06-05 13:39:26.374= UTC [5152] ERROR: =C2=A0cannot use PL/Java before successfully completing = its setup
2020-06-05 13:39:26.374 UTC [5152] HINT: =C2=A0Check the log f= or messages closely preceding this one, detailing what step of setup failed= and what will be needed, probably setting one of the "pljava." c= onfiguration variables, to complete the setup. If there is not enough help = in the log, try again with different settings for "log_min_messages&qu= ot; or "log_error_verbosity".

= I hope you can shed some light on this.
--0000000000005682b505a7567657--