Re: [GENERAL] DATA Integrity & Recovery - Mailing list pgsql-general

From Rich Shepard
Subject Re: [GENERAL] DATA Integrity & Recovery
Date
Msg-id alpine.LNX.2.11.1707120733430.16051@localhost
Whole thread Raw
In response to [GENERAL] DATA Integrity & Recovery  (chris faber <chris@techfaber.com>)
List pgsql-general
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,

   I am very far from being a postgres admin expert, but my understanding
from years ago is that general system backups (and I use dirvish every day
for incremental backups of all partitions) are different from
postgres-specific backups using pg_dump and pg_dumpall. I never looked into
the differences or why they mattered, but each week I run pg_dumpall and
save the .sql file in a database_backup/ directory.

   This does not answer your specific questions but does offer a strategy for
future operations.

HTH,

Rich


pgsql-general by date:

Previous
From: "Hu, Patricia"
Date:
Subject: Re: [GENERAL] loading file with en dash character into postgres 9.6.1database
Next
From: Albe Laurenz
Date:
Subject: Re: [GENERAL] DATA Integrity & Recovery