Hello Hackers,
I have a question regarding the contents being written to the backup_label file and the .backup file in the pg_wal location generated when the online backup is done.
backup_label file contents are as follows, which do not contain backup stop position (timestamp and STOP WAL location). The below information is written when pg_start_backup() is done.
START WAL LOCATION: 0/44000060 (file 000000010000000000000044)
CHECKPOINT LOCATION: 0/44000098
BACKUP METHOD: pg_start_backup
START TIME: 2016-11-04 14:24:25 AEDT
I see the following contents in the file "000000010000000000000044.00000060.backup" which was generated in the pg_wal location during the online backup. When pg_stop_backup() is executed, the following content is written which includes the content copied from the backup_label file.
START WAL LOCATION: 0/44000060 (file 000000010000000000000044)
STOP WAL LOCATION: 0/44000168 (file 000000010000000000000044)
CHECKPOINT LOCATION: 0/44000098
BACKUP METHOD: pg_start_backup
START TIME: 2016-11-04 14:24:25 AEDT
STOP TIME: 2016-11-04 14:25:09 AEDT
Can someone please help me know the importance of the above file ?
How about having the same contents in the backup_label file as well ?
I am working on another patch and was thinking it would be good if the same contents can be written to backup_label file as well. Actually, it would be more beneficial to do so.
As of now, the backup_label file does not have any information related to when and at what position the backup actually completed.
Any thoughts / apprehensions ?
Regards,
Venkata B N
Database Consultant
Fujitsu Australia