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 thro
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 restore
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,
