No primary key set for in postgres to postgres incremental replication

[zebesh]

My config:
tap:

id: postgres-aff
name: postgres-aff
type: tap-postgres
db_conn:
host: 1.1.1.1
port: 12345
user: user
password: qwerty
dbname: DB
target: postgres-target
schemas:

• source_schema: myscheme
  target_schema: myscheme_pipe
  tables:
  • table_name: mytable
    replication_method: INCREMENTAL
    replication_key: id

target:
id: postgres-target
name: postgres-target
type: target-postgres
db_conn:
host: host
port: 5432
user: postgres
password: 123456
dbname: DB2

and when i create import, i get this error:

        IMPORTING YAML CONFIGS FINISHED
        -------------------------------------------------------
            Total targets to import        : 1
            Total taps to import           : 1
            Taps imported successfully     : 0
            Taps failed to import          : ["Post import tap checks failed in tap postgres-aff: ['No primary key set for myscheme-mytable stream (INCREMENTAL)']"]
            Runtime                        : 0:00:00.920105

how fix it?

[Samira-El]

Hi, as the error says, the table is missing a Primary key, you have to add one to the table to do incremental sync.