Re: Netapp SnapCenter - Mailing list pgsql-general

From Magnus Hagander
Subject Re: Netapp SnapCenter
Date
Msg-id CABUevEwUCkjgq1pWnXpiNbgJ+oGaBU7+_kjM6Rps1HnOoUGN6w@mail.gmail.com
Whole thread Raw
In response to Re: Netapp SnapCenter  (Paul Förster <paul.foerster@gmail.com>)
Responses Re: Netapp SnapCenter
List pgsql-general
On Sat, Jun 20, 2020 at 9:04 AM Paul Förster <paul.foerster@gmail.com> wrote:
Hi Stephen,

> On 19. Jun, 2020, at 18:02, Stephen Frost <sfrost@snowman.net> wrote:
> When it comes to 'backup mode', it's actually the case that there can be
> multiple backups running concurrently because there isn't actually a
> single 'cluster wide backup mode', really.

this is what I don't understand. Why would there be a reason to run multiple backups concurrently? I mean, using pg_start_backup() means I then have to backup (using whatever method) of the while PGDATA and not just some random file ${PGDATA}/base/13297/2685. And since I have to backup the whole of PGDATA anyway, why would I want to do that multiple times, even more so, concurrently?

I read the backup doc but I just can't grasp the idea of why multiple concurrent backup capabilities should yield any benefit at all.

One not uncommon case is for example being able to provision a new replica while a backup is running. Since replicas are provisioned starting off a base backup, being able to run that concurrently is very useful. Especially if base backups take a long time to run.

--

pgsql-general by date:

Previous
From: Srinivasa T N
Date:
Subject: Re: Unable to init and run postgresql-12 on centos 8.2.2004
Next
From: Ron
Date:
Subject: Re: The backup API and general purpose backup software