| From: | andy rost <Andy(dot)Rost(at)noaa(dot)gov> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | pg_controldata output documentation |
| Date: | 2006-12-13 22:25:59 |
| Message-ID: | 45807DF7.2020307@noaa.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I'd like to calculate the name of the WAL file associated with the
latest checkpoint using the output from pg_controldata:
Latest checkpoint location: 74/FD9827C0
Prior checkpoint location: 74/FD6FCDC8
Latest checkpoint's REDO location: 74/FD87DDF8
Latest checkpoint's UNDO location: 0/0
Latest checkpoint's TimeLineID: 1
Latest checkpoint's NextXID: 121153385
Latest checkpoint's NextOID: 133301
Latest checkpoint's NextMultiXactId: 1
Latest checkpoint's NextMultiOffset: 0
Is it as simple as 0000000100000074000000FD using Latest checkpoint's
TimeLineID for the first 8 characters and Latest checkpoint location for
the remaining 16 characters?
I'm not running PG ver 8.2 so I don't have access to pg_xlogfile_name
Many thanks ...
Andy
--
--------------------------------------------------------------------------------
Andrew Rost
National Operational Hydrologic Remote Sensing Center (NOHRSC)
National Weather Service, NOAA
1735 Lake Dr. West, Chanhassen, MN 55317-8582
Voice: (952)361-6610 x 234
Fax: (952)361-6634
andy(dot)rost(at)noaa(dot)gov
http://www.nohrsc.noaa.gov
--------------------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-12-13 22:28:44 | Re: a question for the way-back machine |
| Previous Message | Ben | 2006-12-13 22:23:47 | Re: a question for the way-back machine |