Re: EXTERNAL: Re: Netapp SnapCenter - Mailing list pgsql-general

From Magnus Hagander
Subject Re: EXTERNAL: Re: Netapp SnapCenter
Date
Msg-id CABUevExuShgynZWUa1+BBvsTxC2QgQ0gfYYOFZf+dkcFQPUdrw@mail.gmail.com
Whole thread Raw
In response to Re: EXTERNAL: Re: Netapp SnapCenter  (Paul Förster <paul.foerster@gmail.com>)
Responses Re: EXTERNAL: Re: Netapp SnapCenter
List pgsql-general


On Thu, Jun 25, 2020 at 5:23 PM Paul Förster <paul.foerster@gmail.com> wrote:
Hi Ken,

> On 25. Jun, 2020, at 17:15, Wolff, Ken L <ken.l.wolff@lmco.com> wrote:
> There's actually a lot of good stuff in that document about Postgres in general.  I'd be curious to hear what everyone thinks, though, and specifically about what NetApp recommends in Section 3.3 about putting data and WAL on separate volumes, which I believe contradicts what's been discussed in this email thread.

yes, I've read the part about different volumes and I must say, I don't agree because I think it violates atomicity.

I believe NetApp does atomic snapshots across multiple volumes, if you have them in the same consistency group. (If you don't then you're definitely in for a world of pain if you ever have to restore)

Snapshotting multiple volumes in a consistency group will set up a write fence across them, then snapshot, and AIUI guarantees correct write ordering.

--

pgsql-general by date:

Previous
From: Ishan Joshi
Date:
Subject: RE: Postgres server 12.2 crash with process exited abnormally andpossibly corrupted shared memory
Next
From: Paul Förster
Date:
Subject: Re: EXTERNAL: Re: Netapp SnapCenter