pg_controldata output documentation
От | andy rost |
---|---|
Тема | pg_controldata output documentation |
Дата | |
Msg-id | 45807DF7.2020307@noaa.gov обсуждение исходный текст |
Список | 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.rost@noaa.gov http://www.nohrsc.noaa.gov --------------------------------------------------------------------------------
В списке pgsql-general по дате отправления: