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 <chris@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 advance
Chris