Hi all, Lately, in order to extract some information from a backup_label file in python I have found myself doing something like the following to get a timeline number (feel free to reuse that code, especially the regex pattern): pattern = re.compile('^START WAL LOCATION:.*([0-9A-F]+\/[0-9A-F]+).*\(file ([0-9A-F]+)\)') if pattern.match(backup_lable_line): current_lsn = m.group(1) current_segment = m.group(2) current_tli = str(int(current_segment[:8], 16))
That's more or less similar to what read_backup_label()@xlog.c does using sscanf(), still I keep wondering why we need to go through this much complication to get the origin timeline number of a base backup, information which is IMO as important as the start LSN when working on backup methods. I would find interesting to add at the bottom of the backup_label file a new field called "START TIMELINE: %d" to put this information in a more understandable shape. Any opinions? -- Michael -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers