Re: Postgres Point in time Recovery (PITR), - Mailing list pgsql-general

From Luca Ferrari
Subject Re: Postgres Point in time Recovery (PITR),
Date
Msg-id CAKoxK+5M0ZOS=zaTa60HS94W7qXX14qE+9F+SA2bgX9=7PXaxg@mail.gmail.com
Whole thread Raw
In response to RE: Postgres Point in time Recovery (PITR),  (Daulat Ram <Daulat.Ram@exponential.com>)
Responses Re: Postgres Point in time Recovery (PITR),
List pgsql-general
On Sat, Oct 19, 2019 at 7:46 PM Daulat Ram <Daulat.Ram@exponential.com> wrote:
> One more questions is, how backups are useful if we have streaming replication . As I know, we can promote the
standbyas primary in case of disaster at primary side. Do we need to schedule backups if we have streaming
replication?

Let's speculate a little on that: do you need backups if you have a
RAID-1 configuration?
Replication helps you reduce almost to zero the time to handle a
disaster, backups allow you to recover in a more large time window.

Luca



pgsql-general by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: jsonb_set() strictness considered harmful to data
Next
From: Fabio Ugo Venchiarutti
Date:
Subject: Re: Postgres Point in time Recovery (PITR),