Feature: Pick the latest logical replication proto version based on server version

[lyuboxa]

Feature description

The connector always picks version 1 of the proto, however the protocol has evolved over the years.

As per proto versions defined here

Protocol version. Currently versions 1, 2, 3, and 4 are supported. A valid version is required.

Version 2 is supported only for server version 14 and above, and it allows streaming of large in-progress transactions.
Version 3 is supported only for server version 15 and above, and it allows streaming of two-phase commits.
Version 4 is supported only for server version 16 and above, and it allows streams of large in-progress transactions to be applied in parallel.

[raulb]

Hey @lyuboxa ! Today during the Conduit sync we wondered whether you were still planning on working on this, or we should leave it for a future milestone. Thank you!

[lyuboxa]

Hey @lyuboxa ! Today during the Conduit sync we wondered whether you were still planning on working on this, or we should leave it for a future milestone. Thank you!

Future milestone looks good. My priority next will be to add a schema builder using the new conduit version.