I just finished a point in time recovery from a rsync physical data file
backup + wal archive.Of course it works!You can also achieve the same goal
through pg_basebackup.
By your descriptions, your vendor seems to use logical backup through pg_dump.
Anyway you can only achieve no data loss through physical backup.
Check your contract with your vendor, file a suie if penalty term exists.
steven
-------- 原始訊息 --------自： chris faber <ch...@techfaber.com> 日期： 2017/7/12 22:27
(GMT+08:00) 至： pgsql-general@postgresql.org 主旨： [GENERAL] DATA Integrity &
Recovery
Postgres 9.2
We have a POSTGRES database that we have been backing up via Incremental
backups.
We had an incident where we had to recover from backup. Our software vendor has
completed a restore and we have lost 10 days of data. There is no explanation
as to the reason we have sustained this loss.
I would appreciate the communities help in the following:
1. Determine if data from the incremental backups can be restored or
recovered.2. Determine if data can be recovered from individual files backed up
from main Postgres data directory.
Thanks in advanceChris
