Re: Netapp SnapCenter - Mailing list pgsql-general

From Paul Förster
Subject Re: Netapp SnapCenter
Date
Msg-id 4D23B288-6A0B-4BDB-A723-FC47F2E832C7@gmail.com
Whole thread Raw
In response to RE: Netapp SnapCenter  ("Wolff, Ken L" <ken.l.wolff@lmco.com>)
Responses Re: Netapp SnapCenter
List pgsql-general
Hi Ken,

> On 18. Jun, 2020, at 15:56, Wolff, Ken L <ken.l.wolff@lmco.com> wrote:
> PostgreSQL doesn’t need to be in a special mode for backups to work.

this is curious. Doesn't the PostgreSQL cluster need to be set to backup mode to use SnapCenter?

The problem is, one can't test that and get a reliable answer, because you do 100 backups (snaps) for testing and
restorethose 100 backups, and all may be ok. 

But what about the 1000th snap? Just in that millisecond of the snap, some important information is written to the
volumeon which the PostgreSQL cluster resides and for some reason, it needs to be restored later and this information
islost or may lead to corruption. This is why backup mode exists, after all. Really, no backup mode by a pre/post
scriptwhen snapping? 

This is very surprising to me.

Cheers,
Paul




pgsql-general by date:

Previous
From: "Wolff, Ken L"
Date:
Subject: RE: Netapp SnapCenter
Next
From: Magnus Hagander
Date:
Subject: Re: Netapp SnapCenter