PostgreSQL Sequence Reset

[Keda87]

Hi @osalvador

I've tried to migrate PostgreSQL to PostgreSQL and run successfully.
However, I have an issue when the table uses sequence as the primary key.
after the migration, the new insertion in the sink database reset to 1 as the primary key, instead of using the last sequence.

Is there any solution to deal with this? I find on the documentation but I didn't see any.

here is my configuration.

mode=complete
jobs=5

source.connect.parameter.ApplicationName=ReplicaDB
source.connect=jdbc:postgresql://host-source:9237/db_source
source.user=example
source.password=example

sink.connect=jdbc:postgresql://host-target:5432/db_target
sink.user=target
sink.password=target

for the tables was supplied from the argument following your instruction here #27 (comment)

Thank you in advanced.