Kevin Kempter <kevink@xxxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
