| 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-07 14:54:22 |
| Message-ID: | 45782B1E.3030905@noaa.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Is there any documentation on the output from pg_controldata? Most of it
seems intuitive but I would like something definitive on the following
lines:
Latest checkpoint location: 2F9/B38DE758
Prior checkpoint location: 2F9/A3F688F8
Latest checkpoint's REDO location: 2F9/B38DE758
Latest checkpoint's UNDO location: 0/0
Especially, how do I relate this to the file names in the pg_xlog directory.
Thanks ...
Andy
PS - we're relative newbies but getting there
--
--------------------------------------------------------------------------------
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-07 15:20:29 | Re: Why does explain differ from explan analyze? |
| Previous Message | andy rost | 2006-12-07 14:49:45 | SET statement_timeout |