<p>I need to take daily backup for cockroachdb and push to S3 , its running under EKS cluster with statefulset,  So can anyone suggest the best method to do this please.</p>
<p>Thanks.</p>

shufilkhan
<p>the best way is to use the CockroachDB for backup.</p>
<pre><code>CREATE SCHEDULE schedule_label
  FOR BACKUP INTO 's3://test/backups/schedule_test?AWS_ACCESS_KEY_ID=x&amp;AWS_SECRET_ACCESS_KEY=x'
    WITH revision_history
    RECURRING '@daily';
</code></pre>
<p>you can schedule the exact run time using the RECURRING parameter.</p>
<pre><code>CREATE SCHEDULE schedule_database
  FOR BACKUP DATABASE movr INTO 's3://test/schedule-database?AWS_ACCESS_KEY_ID=x&amp;AWS_SECRET_ACCESS_KEY=x'
    WITH revision_history
    RECURRING '1 0 * * *';
</code></pre>
<p>the documentation link is <a href="https://www.cockroachlabs.com/docs/stable/create-schedule-for-backup.html" rel="nofollow noreferrer">this</a></p>
