ALTER ARCHIVE

Eon Mode only

Modifies an existing restore point archive in one of the following ways:

  • Assign a new owner to the archive.
  • Adjust the maximum number of restore points an archive can hold.

Syntax

ALTER ARCHIVE archive-name { OWNER TO user-name | LIMIT max-restore-points }

Arguments

archive-name
Name of the archive to alter.
OWNER TO user-name
Reassign ownership of the archive to user-name.
LIMIT max-restore-points
Alters the maximum number of restore points that can be stored in the archive. If an archive contains a greater number of restore points than the new max-restore-points limit, the oldest restore point in the archive is deleted until the number of restore points equals max-restore-points. The default value is 'unlimited'.

Privileges

Superuser or archive owner

Examples

Change the restore point limit of the vertica-restore archive to 5:

=> ALTER ARCHIVE vertica-restore LIMIT 5;

See also