Kevin Kempter <kevink@consistentstate.com> wrote:
> Would there be a way to force postgres to recognize the wal
> segments that werte created earlier (which according to the client
> include all tx from 3 weeks ago thru today) ?
No.
The database restored from the output of pg_dump won't have the same
object IDs, row IDs, page locations, etc. Page images in the WAL
files won't correspond to your new database. At all. Period.
Making a PITR backup *now* (as you suggest) will allow you to recover
to what is in the database now, or (as long as you accumulate WAL
files) any future point in time. It won't rearrange the pages in your
current database to resemble the pages in the lost database.
-Kevin