Re: Starting build-system work (Windows/Mac users please speak up)

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.