embulk-output-postgresql

[sureshinforma]

Team - I am struggling to figure this out, would you be able to help me what could be wrong so I can look at right direction to fix this:
Input is TD and Output is PostgreSQL. But it is not working, not sure where is this null:

[hiroyuki-sato]

Hello, @sureshinforma

Could you show us your config without private info?
And paste all stack-trace messages as text.

It seems you use mis configuration.

[sureshinforma]

Thanks @hiroyuki-sato for your response, that was indeed a configuration issue. I am able to sort that out. But needed your guidance on an additional issue.
Error - The authentication type 10 is not supported. Check that you have configured the pg_hba.conf file to include the client's IP address or subnet, and that it is using an authentication scheme supported by the driver.
This is being output in log: embulk-output-postgresql-0.10.2-java/default_jdbc_driver/postgresql-9.4-1205-jdbc41.jar
So is this has to be tweaked on target DB front for authentication? or do we have a plugin version who rather than picking default jdbc version use the one which supports scram-sha-256 encryption as well which has been set up in target DB.

[hiroyuki-sato]

Hello, @sureshinforma You need to use a newer JDBC Driver

Download a newer driver from https://jdbc.postgresql.org

And Add configuration like below.

out:
  type: postgresql
  ...
  driver_path: /path/to/postgresql-42.6.0.jar # path to download driver
  options:
    sslmode: require

• Translated: JDBC Driver and setting method when using PostgreSQL v14 with embulk-input-postgresql
• Original: embulk-input-postgresqlでPostgreSQL v14を使いたいときのJDBC Driverと設定方法

[dmikurube]

We see no response for months. Let me close this discussion.