CREATE ARCHIVE

Eon Mode only

Creates an archive for in-database restore points.

After you create an archive, you can save restore points to it using the SAVE RESTORE POINT TO ARCHIVE statement. The archive stores restore points in descending chronological order based on the time at which the restore points were saved, where an index of 1 specifies the most recently saved restore point.

Syntax

CREATE ARCHIVE archive-name [ LIMIT max-restore-points ]

Arguments

archive-name
Name of the archive to create, where archive-name conforms to conventions described in Identifiers.
max-restore-points
Maximum number of restore points to store in the archive. If an archive contains max-restore-points restore points and a new restore point is created, the oldest restore point in the archive is deleted. The default value is 'unlimited'.

Privileges

Superuser

Examples

The following statement creates an archive named verticadb that stores a maximum of three restore points:

=> CREATE ARCHIVE verticadb LIMIT 3;
CREATE ARCHIVE

To view all archives in the database, query the ARCHIVES system table:

=> SELECT * FROM ARCHIVES;
    name   | limit_count
-----------+-------------
 verticadb |           3
(1 row)

See also