# Pt-archiver --stop and --unstop options for idempotence

**URL:** <https://forums.percona.com/t/pt-archiver-stop-and-unstop-options-for-idempotence/31905>\
**Category:** Percona Toolkit\
**Created:** [July 30, 2024, 1:20pm UTC](https://forums.percona.com/t/pt-archiver-stop-and-unstop-options-for-idempotence/31905 "2024-07-30T13:20:50Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![ghinoads](https://avatars.discourse-cdn.com/v4/letter/g/8e8cbc/32.png) [@ghinoads](https://forums.percona.com/u/ghinoads)\
**Post date:** [July 30, 2024, 1:20pm UTC](https://forums.percona.com/t/pt-archiver-stop-and-unstop-options-for-idempotence/31905/1 "2024-07-30T13:20:50Z")

</div>

Hello,

I was wondering if there is a way to stop and restart a pt-archiver command with a specific WHERE clause, ensuring that the tool restarts exactly from the point where it was stopped, guaranteeing idempotence and avoiding archiving rows that have been already migrated.

I tried to use the options --stop and --unstop, but I did not manage to achieve this goal, since at the restart the tool was trying to archive data already migrated (giving the error duplicate entry for primary key).  
Maybe I’m missing something concerning this options, or there is some other way to achieve idempotence?

Thank you in advance,  
Giulio.