feat: Custom replication slot name

[edgarrmondragon]

Hi everyone. I'm using tap-postgres with LOG_BASED replication method. I've successfully setup the logical replication and now able to capture insert, update, and deletes on my database.

I'm running into an issue that my replication slot cannot be used by parallel extractions from the database. Is there a way to set a different replication slot name for each extractor other than tappostgres?

This should be as easy as adding new setting to tap_postgres/tap.py and passing it to

tap-postgres/tap_postgres/client.py

Lines 343 to 353 in e6dd19c

	logical_replication_cursor.start_replication(
	slot_name="tappostgres",
	decode=True,
	start_lsn=start_lsn,
	status_interval=status_interval,
	options={
	"format-version": 2,
	"include-transaction": False,
	"add-tables": self.fully_qualified_name,
	},
	)

Slack Thread: https://meltano.slack.com/archives/C069CQNHDNF/p1731396392068079