Vertica documentation is moving! Use our new documentation site at https://docs.rocketsoftware.com/bundle/vertica_25.3/page/index.html

ARCHIVES

Eon Mode only

Lists information about In-DB restore points archives.

Column Name Column Type Description
NAME VARCHAR Archive name.
LIMIT_COUNT INT Maximum number of restore points stored in the archive.
OWNER VARCHAR Owner of the archive.

Examples

List all archives and their attributes:

=> select * from archives;
	name     | limit_count | owner
-------------+-------------+-------
 full_backup | 10          | luis
 backup1     | 10          | luis
 (2 rows)