Hello, when running the pgloader command without providing a password, the command should look for the PGPASSWORD env var, but it does not seem to pick it up as I get the following error message:
$ pgloader mysql://user@remote_host/src_db postgresql://postgres@remote_host/dest_db
Exception in thread "main" org.postgresql.util.PSQLException: The server requested SCRAM-based authentication, but no password was provided.
I have double-checked that the env vars are set and they have the correct password as I've been able to login using the env vars and the respective mysql and psql commands.
I also tried running the pgloader command with the env vars inlined and that works
$ pgloader mysql://user:${MYSQL_PWD}@remote_host/src_db postgresql://postgres${PGPASSWORD}@remote_host/dest_db
Does this have anything to do with how Java accepts env vars?
Hello, when running the pgloader command without providing a password, the command should look for the PGPASSWORD env var, but it does not seem to pick it up as I get the following error message:
I have double-checked that the env vars are set and they have the correct password as I've been able to login using the env vars and the respective
mysqlandpsqlcommands.I also tried running the pgloader command with the env vars inlined and that works
Does this have anything to do with how Java accepts env vars?