On Thu, Aug 28, 2008 at 3:35 PM, John T. Dow <john@xxxxxxxxxxxx> wrote: > However, it would really be nice if the WAL files could be used to make the restored data more current, even if not everything can be restored. Are we certain that useful information can't be gleaned from them to apply changes made since the last pg_dump? The WAL files contain changes at the disk block level, not the SQL level. A freshly created and restored database will have a totally different block layout so WAL files would be useless. The other thing you can do with WAL is "warm standby" -- creating a duplicate server by copying the data files from the primary, then arranging for the primary to ship each WAL file, once it's filled, to the standby server, which is running in "permanent PITR" mode. If the primary server takes a dirt nap, you can bring up the standby and it will be current as of the last WAL file that was shipped over. For this to work, both machines must be the same architecture and have identical versions of Postgres. -Doug
