Increase client timeout when bucardo connects to source or a destination DB

[siddharth7]

We have set a global statement timeout for queries on Postgres. While trying to add a sync using bucardo add sync command, the bucardo query that runs on source db fails to acquire a lock in time and gives a statement timeout error from what we can see from our logs. Is there an option to set query timeout for the client used by bucardo to connect to postgres instances?

[jonjensen]

@siddharth7 I don't know offhand, but I do see that Bucardo starts its transactions with:

SET statement_timeout = 0

here: https://github.com/bucardo/bucardo/blob/master/Bucardo.pm#L5129

so unless the code is running through a different path, I wouldn't expect a timeout.