Our Blueprints
Protecting PostgreSQL
pg_probackup is a tool for handling the backup and recovery of PostgreSQL database clusters to a specified file path. Its primary purpose is to facilitate regular backups of the PostgreSQL, allowing for server restoration in the event of a failure.
Requirements Analysis
pg_probackup is a tool designed for managing the backup and restoration of PostgreSQL database clusters via a file path. It is built to perform regular backups of the PostgreSQL instance, ensuring that you can restore the server if a failure occurs.
Data Modeling
A backup refers to the most recent copy of a file or object that is in an ACTIVE state, meaning it will never expire. The state changes only if a new file or object with the same name, including, is stored. In this case, the new object will be set to ACTIVE.
Storage Architecture
Spictera Unified Storage uses storage hierarchies, where the primary storage pool is the initial location for the data. This data can later be transferred to a secondary storage pool depending on usage (Tiered Storage) or other factors. Spictera Unified Storage can access the data no matter its location.
Data Access Patterns
pg_probackup can be configured to run multiple simultaneous copy operations, with each operation being a sequential copy process, which makes it ideal for a wide range of devices connected to the IBM Storage Protect server, ensuring efficient backup management.
Scalability and Performance
Spictera Unified Storage scales both horizontally, by enabling more simultaneous access to the same node with direct access to the storage devices or allowing connections to multiple IBM Storage Protect servers simultaneously, and vertically, by tiering multiple IBM Storage Protect servers.
Data Security
Encryption in transit is enabled by default, and it allows either a negotiated encryption key or a custom key. Encryption at rest can be configured for the targeted storage pool used by IBM Storage Protect or by utilizing hardware that supports such operations, like Tape.
Backup and Recovery
IBM Storage Protect can be configured to create duplicate copies (COPY STORAGEPOOL) or enable replication (REPLICATE NODE/PROTECT STORAGEPOOL). This setup provides protection against media failures and physical damage, especially when the secondary copy is stored.
Conclusion
This document highlights the versatility of Spictera Unified Storage, covering its various features and capabilities. It explores how Spictera Unified Storage can be leveraged for different storage needs. Additionally, it provides insights into its flexibility in diverse environments.
01
White Papers
02
Manuals
03
Blue Prints
