Re: [GENERAL] DATA Integrity & Recovery

2017-07-12 Thread stevenchang1213
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

Re: [GENERAL] DATA Integrity & Recovery

2017-07-12 Thread Albe Laurenz
chris faber wrote: > Postgres 9.2 > > We have a POSTGRES database that we have been backing up via Incremental > backups. You are talking of a physical base backup and WAL archives, right? > We had an incident where we had to recover from backup. Our software vendor > has completed > a

Re: [GENERAL] DATA Integrity & Recovery

2017-07-12 Thread Rich Shepard
On Wed, 12 Jul 2017, chris faber wrote: 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. Chris,

[GENERAL] DATA Integrity & Recovery

2017-07-12 Thread chris faber
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