Hi all, just a question on db replication i,e one postgres source to another postgres destination. Suppose I have a connection set-up to run nightly, if I change the source schema by adding new columns to a table or adding a new table to a database, will I have to refresh this source or can the connection detect this change?

My understanding is that additional columns should not require any changes, just make sure the postgres user has appropriate permissions. For new tables, you will need to check those permissions as well as reconfigure the source connector to specify which tables you want to pull in. If you're using CDC, you should alter the postgres publication too. This all may trigger a full refresh sync, but don't worry it should go back to incremental afterwards!