PostgreSQL Connector: Add support mutual TLS (client certificate auth)

[can-oezkan]

Problem Description

Currently I can use the postgresql connector with the following configuration:

connectors/app/connectors_service/connectors/sources/postgresql/client.py

Lines 27 to 41 in d19a0a6

	def __init__(
	self,
	host,
	port,
	user,
	password,
	database,
	schema,
	tables,
	ssl_enabled,
	ssl_ca,
	logger_,
	retry_count=DEFAULT_RETRY_COUNT,
	fetch_size=DEFAULT_FETCH_SIZE,
	):

There is no option to configure the connector to use mutual TLS.

https://www.elastic.co/docs/reference/search-connectors/es-connectors-postgresql

Proposed Solution

It would like to be able to use client certificate auth.

The connection string with mutual TLS would look something like this:

postgresql://{host}:{port}/{database}?sslmode=prefer&sslkey={path to client.key}&sslcert={path to client.crt}&user={user}

Additional Context

[Samiul-TheSoccerFan]

Hi @can-oezkan ,

Thank you for raising this issue. It seems like a valid request, and we would like you to submit a formal enhancement request. I am currently looking into the process for external users, and I will update this thread as soon as I have more information so you can submit it officially.

[Samiul-TheSoccerFan]

Hi @can-oezkan, if you have a support relationship with Elastic, please ask your support/sales representative to help you create an Enhancement Request.

[can-oezkan]

@Samiul-TheSoccerFan, thanks for the follow up! Will do.