From: | Stephen Harris <lists(at)spuddy(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_controldata output documentation |
Date: | 2006-12-07 17:09:00 |
Message-ID: | 20061207170900.GA22068@pugwash.spuddy.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Dec 07, 2006 at 08:54:22AM -0600, andy rost wrote:
> 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.
http://www.postgresql.org/docs/8.2/static/functions-admin.html
pg_xlogfile_name_offset() and pg_xlogfile_name_()
eg
testdb=# select pg_xlogfile_name_offset('2F9/B38DE758');
pg_xlogfile_name_offset
------------------------------------
(00000001000002F9000000B3,9299800)
(1 row)
testdb=# select pg_xlogfile_name('2F9/B38DE758');
pg_xlogfile_name
--------------------------
00000001000002F9000000B3
(1 row)
--
rgds
Stephen
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Davis | 2006-12-07 17:27:26 | Re: Online index builds |
Previous Message | Zoltan Boszormenyi | 2006-12-07 17:01:13 | Re: Internal function call from C-language function |