Support SSL connection for Neon postgres cdc backfill

[StrikeW]

Is your feature request related to a problem? Please describe.

Neon requires that all connections use SSL/TLS encryption. (link)

dev=> create source neondb with (
 connector = 'postgres-cdc',
 hostname = 'xx.aws.neon.tech',
 port = '5432',
 username = 'user',
 password = 'pass',
 database.name = 'neondb',
 slot.name = 'neon_slot',
 transactional = 'true'
 );
CREATE_SOURCE

dev=> create table neon_t (
    v1 integer primary key,
    v2 float
) from neondb table 'public.t';
ERROR:  Failed to run the query

Caused by these errors (recent errors listed first):
  1: gRPC request to meta service failed: Internal error
  2: gRPC request to stream service failed: Internal error
  3: Executor error
  4: Connector error
  5: Postgres error
  6: db error
  7: ERROR: connection is insecure (try using `sslmode=require`)

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response

[github-actions[bot]]

This issue has been open for 60 days with no activity. Could you please update the status? Feel free to continue discussion or close as not planned.