Mike C <smith.not.western@xxxxxxxxx> 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
