- 21 Mar 2022
- 1 Minute to read
- Print
- DarkLight
- PDF
Backing Up the Database
- Updated on 21 Mar 2022
- 1 Minute to read
- Print
- DarkLight
- PDF
CTERA Portal uses PostgreSQL to store metadata. This database must be backed up to ensure continued use of CTERA Portal in order to ensure data and metadata persistence and consistency on the CTERA platform, and to keep Recovery Time Objective (RTO) and Recovery Point Objective (RPO) values to a minimum.
Calculating the Minimum Space Required for the Database Backup
The database storage used for backup does not have SSD storage. You require double the storage for the backup. For example, if the primary database uses 1TB storage and a secondary, replication, database uses another 1TB, then each of these databases require 2TB for backup. The storage pool must be at least 6TB: 1TB for the primary database, 1TB for the secondary database and 4TB for the primary and secondary backup (2TB for each backup).
You must define a database archive pool, whether using PostgreSQL continuous archiving or PostgreSQL Streaming Replication. Both Using PostgreSQL Continuous Archiving and Using PostgreSQL Streaming Replication procedures describe how to create an archive pool.