Mike C <smith.not.western@gmail.com> writes:
> I guess if pg_dump was modified to record the last complete transaction id
> (in archive format maybe) then the WAL files could be used?
No. pg_dump output and WAL files are at two utterly different levels of
abstraction --- the WAL files describe the exact placement of tuples
within tables and indexes, to mention just one example. There's no hope
of using pg_dump output to reproduce the state of a database exactly
enough that you could apply WAL files to it.
regards, tom lane
