Beginners problem with retention policy

Store
1

Problem with retention policy
Hello
I am a newbie to InfluxDB and to this forum. A while ago I created my first database and set a retention policy.
When I did a “show retention policy” today I got to see the following.
SHOW RETENTION POLICIES ON “SW”
name duration shardGroupDuration replicaN default

autogen 0s 168h0m0s 1 true
eenjaar 8736h0m0s 168h0m0s 1 false

Should I leave that autogen or can it be removed and how should I do this?
I hope someone can help me with that beginner question.

Thanks
Hervé

2

I believe you should make the eenjaar retention policy default first. The command:
ALTER RETENTION POLICY “eenjarr” on “SW” DEFAULT
should do it.
Then you can drop the autogen policy, this will result in a loss of data if any points have been stored in the autogen policy.
DROP RETENTION POLICY “autogen” ON “SW”

You can avoid creating the autogen policy when you create a database by using the syntax
CREATE DATABASE “mydb” with DURATION 168h NAME “oneweek”

3

Thank you very much Neil. I again learned something about using InfluxDB.

Hervé