Postgres Pro
Downloads
Home   >   mailing lists

Re: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools? - Mailing list pgsql-general

From Rob Sargent
Subject Re: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools?
Date
Msg-id 26bf6de1-4a05-54b1-13ea-ce8c56e79344@gmail.com
Whole thread Raw
In response to RE: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools?  (HECTOR INGERTO <hector_25e@hotmail.com>)
Responses Re: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools?  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
Tree view
On 1/18/23 09:38, HECTOR INGERTO wrote:
@font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0cm; font-size:11.0pt; font-family:"Calibri",sans-serif;}a:link, span.MsoHyperlink {mso-style-priority:99; color:blue; text-decoration:underline;}.MsoChpDefault {mso-style-type:export-only;}div.WordSection1 {page:WordSection1;}

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.


pgsql-general by date:

Previous
From: HECTOR INGERTO
Date:
Subject: RE: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools?
Next
From: "Dirschel, Steve"
Date:
Subject: Interpreting postgres execution plan along with AND/OR precedence