I have a feature request that I'd like to see implemented for the postgres connector.
I have set up the postgres connector to synchronise using logical replication which appears to work without issue, I followed the instructions found here: https://fivetran.com/docs/databases/postgresql/setup-guide#logicalreplicationsetup
This works fine, but I think there should be an option for this connector to work in an "append only" mode. How it works now is that the connector will _update_ my destination tables so that they look like the Postgres table, effectively keeping the tables in sync (except deletes). This is probably what some people want, however it isn't really the best way to build a staging area for a data warehouse. It would be better if all changes made in postgres were _inserted_ into the destination table rather than making updates to the destination table. There would also need to be a flag in the destination table which would indicate if the record is a DELETE, INSERT or UPDATE operation.
Would be great to see something like this implemented