Changing shard duration for retention policy

I want to change my shard duration from 1w to 4w for my default retention policy, and I think the following command should do:
ALTER RETENTION POLICY “autogen” ON “myDatabase” DURATION INF SHARD DURATION 4w DEFAULT

However, it looks like this will not change any of the existing shards, only when creating new ones? Is this correct, and how can I make Influx update/merge existing shards (Four shards into one)?

@hpbieker Thats not a supported operation! Sorry! You would need to create a new db.rb with that shard duration and write that same data into it.

1 Like