From: | Venkata B Nagothi <nag1010(at)gmail(dot)com> |
---|---|
To: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Contents of "backup_label" and "*.backup" in pg_wal location |
Date: | 2016-11-04 04:18:47 |
Message-ID: | CAEyp7J-bF5eFggaB0X=Rw7TPm5kzz9x6TeCXGFO5JasyqqY8dw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
BACKUP FROM: master
START TIME: 2016-11-04 14:24:25 AEDT
LABEL: 222
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
BACKUP FROM: master
START TIME: 2016-11-04 14:24:25 AEDT
LABEL: 222
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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2016-11-04 04:44:15 | Re: Contents of "backup_label" and "*.backup" in pg_wal location |
Previous Message | Ashutosh Bapat | 2016-11-04 04:08:17 | Re: Push down more full joins in postgres_fdw |