Re: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools?

Ron Johnson <ronljohnsonjr@gmail.com>

From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-general@lists.postgresql.org
Date: 2023-01-18T17:26:51Z
Lists: pgsql-general
On 1/18/23 10:54, Rob Sargent wrote:
> On 1/18/23 09:38, HECTOR INGERTO wrote:
>>
>> I wanted to understand the underlying issue.
>>
>> I use ZFS snapshots instead of a “correct” backup because with only two 
>> machines it allows me to have backups in the main machine and in the 
>> secondary too that acts as hotspare at the same time.
>>
>> To accomplish the same I would need 3 nodes. The main, the replica 
>> hotspare and the proper backup.
>>
>
> Isn't "proper backup" typically thought of as offsite reloadable file 
> capture, hopefully relatively recent?  Disaster recovery, and all that.

That is in fact what "proper backup" means.  "Hot spare" means high 
availability, and *HA is not DR*.



-- 
Born in Arizona, moved to Babylonia.