From: | Luca Ferrari <fluca1978(at)gmail(dot)com> |
---|---|
To: | Daulat Ram <Daulat(dot)Ram(at)exponential(dot)com> |
Cc: | Avinash Kumar <avinash(dot)vallarapu(at)gmail(dot)com>, David Steele <david(at)pgmasters(dot)net>, Andreas Joseph Krogh <andreas(at)visena(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Postgres Point in time Recovery (PITR), |
Date: | 2019-10-21 08:52:18 |
Message-ID: | CAKoxK+5M0ZOS=zaTa60HS94W7qXX14qE+9F+SA2bgX9=7PXaxg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sat, Oct 19, 2019 at 7:46 PM Daulat Ram <Daulat(dot)Ram(at)exponential(dot)com> wrote:
> One more questions is, how backups are useful if we have streaming replication . As I know, we can promote the standby as 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
From | Date | Subject | |
---|---|---|---|
Next Message | Fabio Ugo Venchiarutti | 2019-10-21 10:49:42 | Re: Postgres Point in time Recovery (PITR), |
Previous Message | Tomas Vondra | 2019-10-21 06:07:01 | Re: jsonb_set() strictness considered harmful to data |