Postgres support lock_timeout

[suonto]

Issue Creation Checklist

• I understand that my issue will be automatically closed if I don't fill in the requested information
• I have read the contribution guidelines

Feature Description

Support passing lock_timeout to pg client.

Lock timeout support was added to pg in 8.8.0:

• pg changelog: https://github.com/brianc/node-postgres/blob/c99fb2c127ddf8d712500db2c7b9a5491a178655/CHANGELOG.md#pg880
• pg PR: Support lock_timeout brianc/node-postgres#2779

Implementation

Pick also 'lock_timeout' here:

sequelize/src/dialects/postgres/connection-manager.ts

Line 71 in 43bca57

const connectionConfig: ClientConfig = {

Describe why you would like this feature to be added to Sequelize

Lock timeout is useful. Otherwise the underlying tech wouldn't support it.

Is this feature dialect-specific?

• No. This feature is relevant to Sequelize as a whole.
• Yes. This feature only applies to the following dialect(s): postgres

Would you be willing to resolve this issue by submitting a Pull Request?

• Yes, I have the time and I know how to start.
• Yes, I have the time but I will need guidance.
• No, I don't have the time, but my company or I are supporting Sequelize through donations on OpenCollective.
• No, I don't have the time, and I understand that I will need to wait until someone from the community or maintainers is interested in implementing my feature.

---

Indicate your interest in the addition of this feature by adding the 👍 reaction. Comments such as "+1" will be removed.

[WikiRik]

Seems like you already know how to implement this, is there any reason you do not have the time to open a PR? Since it's just an option to pass to the node-postgres package I do not really see more work that needs to be done

[suonto]

I can try to make time. You're right, shouldn't take long.