I'm working on a script that takes backups in intervals from our warm
PITR stand by server (both servers running PG 8.2.5). The
documentation advises "running pg_controldata on the standby server
to inspect the control file and determine the current checkpoint WAL
location". I am hoping someone can confirm how to perform this step.
From pg_controldata:
Latest checkpoint location: 8E/624808
Latest checkpoint's TimeLineID: 1
Using the timeline id of 1, log id of 8E and log segment of 0, the
oldest WAL needed for a recoverable backup is 000000010000008E00000000
It's not obvious to me why the output in this example doesn't
indicate a log segment of 62 and offset of 4808, or a log segment of
6 and offset of 24808. It would be less ambiguous if pg_controldata
didn't strip leading zeros from the log segment so that the first two
hex digits after the slash would be the log segment. What is the rule
for determining the log segment from pg_controldata's output?
Thanks for the help!
Brian Wipf
ClickSpace Interactive Inc.
<brian@clickspace.com>