| From: | Paul Förster <paul(dot)foerster(at)gmail(dot)com> |
|---|---|
| To: | "Wolff, Ken L" <ken(dot)l(dot)wolff(at)lmco(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Netapp SnapCenter |
| Date: | 2020-06-18 14:07:16 |
| Message-ID: | 4D23B288-6A0B-4BDB-A723-FC47F2E832C7@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi Ken,
> On 18. Jun, 2020, at 15:56, Wolff, Ken L <ken(dot)l(dot)wolff(at)lmco(dot)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 restore those 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 volume on which the PostgreSQL cluster resides and for some reason, it needs to be restored later and this information is lost or may lead to corruption. This is why backup mode exists, after all. Really, no backup mode by a pre/post script when snapping?
This is very surprising to me.
Cheers,
Paul
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2020-06-18 14:19:32 | Re: Netapp SnapCenter |
| Previous Message | Wolff, Ken L | 2020-06-18 13:56:00 | RE: Netapp SnapCenter |