{"repo":"ConduitIO/conduit-connector-postgres","free":true,"listed":false,"github":"https://github.com/ConduitIO/conduit-connector-postgres","clone":"git clone https://github.com/ConduitIO/conduit-connector-postgres.git","description":"Conduit connector for PostgreSQL","language":"Go","stars":19,"topics":["go","golang","postgresql","conduit"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"Conduit Connector PostgreSQL The PostgreSQL connector is a Conduit plugin. It provides both, a source and a destination PostgresSQL connector. Source The Postgres Source Connector connects to a database with the provided url and starts creating records for each change detected in the provided tables. Upon starting, the source takes a snapshot of the provided tables in the database, then switches into CDC mode. In CDC mode, the plugin reads from a buffer of CDC events. Snapshot When the connector first starts, snapshot mode is enabled. The connector acquires a read-only lock on the tables, and then reads all rows of the tables into Conduit. Once all rows in that initial snapshot are read the connector releases its lock and switches into CDC mode. This behavior is enabled by default, but can be turned off by adding \"snapshotMode\": \"never\" to the Source configuration. Change Data Capture This connector implements Change Data Capture (CDC) features for PostgreSQL by creating a logical replication slot and a publication that listens to changes in the configured tables. Every detected change is converted into a record. If there are no records available, the connector blocks until a record is available or the connector receives a stop signal. Logical Replication Configuration When the connector switches to CDC mode, it attempts to run the initial setup commands to create its logical replication slot and publication. It will connect to an existing slot if one with the configured name","default_branch":null,"files":null,"tree":[],"storefront":"/r/ConduitIO","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/ConduitIO/conduit-connector-postgres/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}