ALTER PITR¶
ALTER PITR changes the retention range of an existing PITR. You need permission to manage that PITR. See CREATE PITR for its scope.
Syntax¶
ALTER PITR pitr_name RANGE value unit;
pitr_name is the name of an existing PITR. See CREATE PITR parameters for the values of value and unit.
Example¶
Replace your_pitr with the name of an existing PITR that you can manage, and change its retention range to two hours:
ALTER PITR your_pitr RANGE 2 'h';
SHOW PITR WHERE pitr_name = 'your_pitr';
Check pitr_length and pitr_unit in the result. Confirm that the new retention range meets your recovery requirements before changing it.
Last updated on