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 https://github.com/osalvador/ReplicaDB/issues/27#issuecomment-862229297

Thank you in advanced.