Hi,
So I had to make some changes to the way that backup worked with
PBMS in order that it would behave as expected when the BLOB data
is stored remotely on an S3 server.
I will go over how the PBMS repository is backed up first and
then explain how it works with S3 storage.
PBMS provides a pbms_backup table in its 'pbms' database that
records all the backups that have been performed on any of the
PBMS repositories on the server. The create statement for this
table looks like this:
CREATE TABLE pbms.pbms_backup (
id INT NOT NULL AUTO_INCREMENT,
Database_Name VARCHAR(64) NOT NULL,
Started TIMESTAMP,
Completed TIMESTAMP,
IsRunning BOOL,
IsDump BOOL,
Location VARCHAR(1024),
Cloud_Ref INT,
Cloud_backup_no INT,
PRIMARY KEY (id)
)
There are 2 ways to backup a PBMS repository:
- …
