Add statement timeout for PostgreSQL

embulk / embulk-input-jdbc

MySQL, PostgreSQL, Redshift and generic JDBC input plugins for Embulk

Other

102 stars 74 forks source link

Add statement timeout for PostgreSQL #220

Closed hieudion closed 3 years ago

hieudion commented 3 years ago

statement_timeout is used quite useful in some cases. I would like to add this option to embulk_input_postgresql

dmikurube commented 3 years ago

JFYI, embulk-input-sqlserver's checks are fixed separete in #221.

dmikurube commented 3 years ago

Thanks!

yasutaka-emoto commented 3 years ago

Hi, Could you tell me what parameter name we should set in yaml file to change statement timeout of postgres ? Is is correct "setStatementTimeout" and we have to set value as millisecond ?

hiroyuki-sato commented 3 years ago

Hello, @yasutaka-emoto

Could you try the following?

embulk-input-postgresql: 0.12.3
statement_timeout_millis

https://github.com/embulk/embulk-input-jdbc/pull/220/files#diff-6058ddaf7edb070082c1f68aa2f481a21a7cbfb072dbfb3eae2bf28dbace418eR57

yasutaka-emoto commented 3 years ago

@hiroyuki-sato Hi, Thank you for your quick replying ! I will try it to check whether it works.