[HACKERS] 8.5 TODO: any info on "Create dump tool for write-ahead logs..." in PITR section (1.4)?

2009-10-02 Thread shakahsha...@gmail.com
Can anyone elaborate (or point me to some additional info) on the 8.5
TODO item in the "Point-In-Time Recover (PITR) section (1.4)":
  Create dump tool for write-ahead logs for use in determining
transaction id for point-in-time recovery
 This is useful for checking PITR recovery.

I poked around a bit and found some code that "walks" the WAL logs (in
src/backend/access/transam/xlog.c, I think) and I could probably
figure out how to display a WAL log file contents, but I'm hoping
someone can provide some context as to what issue this TODO item is
trying to address (i.e., what output would be useful).

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


[HACKERS] 8.5 TODO: Add comments to output indicating version of pg_dump and of the database server

2009-09-25 Thread shakahsha...@gmail.com
>From pg_dump/pg_restore section (9.2 of the Todo page on the
PostgreSQL Wiki), is the following item
  "Add comments to output indicating version of pg_dump and of the
database server"

simply asking for a change to the pg_dump header from:

--
-- PostgreSQL database dump
--

to something like:

-- PostgreSQL database dump
--
-- pg_dump version: 8.5devel
--
-- remote database version: 8.5devel (80500)
--

?

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers