Hey, I was tryng to tap a Postgres Instance, and i...
# getting-startedj
jarrell_dunson
05/18/2023, 8:03 PMHey, I was tryng to tap a Postgres Instance, and it said: Plugin configuration is invalid, Exception: Unrecognized replication_method None .... I don't use any replication method... do I just put in a null/empty value?
p
pat_nadolny
05/18/2023, 8:16 PM@jarrell_dunson check out https://docs.meltano.com/guide/integration#setting-metadata for tips on setting replication metadata. Ideally taps would default to full table but we still see some older taps that require it to be set. We also have been working on a new SDK based tap-postgres that hasnt been promoted to the default variant yet that you might want to consider using https://hub.meltano.com/extractors/tap-postgres--meltanolabs/
j
jarrell_dunson
05/19/2023, 1:28 PMPat, not sure I understand what you mean. Do you mean I have to use 'full table' ? As for the new link, there are multiple settings we/I don't use (e.g., ssh tunneling, for instance).
p
pat_nadolny
05/19/2023, 1:48 PM@jarrell_dunson yes sorry I wasnt super clear. It looks like this tap is requiring that you set a replication method before the sync will work, the simplest thing to do is run
Copy code
meltano config tap-postgres set _metadata '*' replication-method FULL_TABLEpat_nadolny
05/19/2023, 1:51 PMThat will tell the tap how to replicate data, other options being INCREMENTAL or LOG_BASED. Ideally taps would be built with a default value, FULL_TABLE, so syncs work without any additional configurations.
pat_nadolny
05/19/2023, 1:52 PMRelated to the meltanolabs variant - those SSH settings disabled by default so you dont need to configure them if you dont need them