Mike C <smith(dot)not(dot)western(at)gmail(dot)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
In response to
pgsql-admin by date
|Next:||From: Michael Fuhr||Date: 2005-12-22 23:57:01|
|Subject: Re: lo_ functions|
|Previous:||From: Tom Lane||Date: 2005-12-22 23:21:38|
|Subject: Re: Create Index Locking Question |