MIME-Version: 1.0
References: <CAC5iy60ZzcsxL1GKAdUdiqA7TFv_yQW3ZkN07VJM8J1Xkdk8Gg@mail.gmail.com>
 <e5e1bd6610da84292deb7ba0a3196b66f0b1bef7.camel@cybertec.at>
 <CAC5iy60NgOv2nRYNwSh2n-Pj82eUjghgWjV2VCuQUABsAZ9uiw@mail.gmail.com>
 <143af5f7-94c1-453b-803e-12f162780a83@aklaver.com> <f2fbd780-f0c1-4aac-b136-913da043e82c@dalibo.com>
In-Reply-To: <f2fbd780-f0c1-4aac-b136-913da043e82c@dalibo.com>
From: Siraj G <tosiraj.g@gmail.com>
Date: Fri, 21 Mar 2025 19:37:46 +0530
Message-ID: <CAC5iy63orsh6axhJEtQGOs4qTHbnqTFrsj12SZx8MRgaJovyWw@mail.gmail.com>
Subject: Re: Export operation efficiency in read replica
To: Guillaume Lelarge <guillaume.lelarge@dalibo.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000239da30630dac888"
Archived-At: <https://www.postgresql.org/message-id/CAC5iy63orsh6axhJEtQGOs4qTHbnqTFrsj12SZx8MRgaJovyWw%40mail.gmail.com>
Precedence: bulk

--000000000000239da30630dac888
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Thank you everyone!

On Fri, Mar 21, 2025 at 7:23=E2=80=AFPM Guillaume Lelarge <
guillaume.lelarge@dalibo.com> wrote:

> On 20/03/2025 15:04, Adrian Klaver wrote:
> > On 3/20/25 05:58, Siraj G wrote:
> >> Hello Laurenz
> >>
> >> As per my understanding coming to a proper conclusion wrt RPO
> >
> > You still have not defined what RPO is.
> >
>
> I guess the OP is talking about Recovery Point Objective, which is one
> of two important parameters WRT to disaster recovery. It's the maximum
> data loss you agree on with your backup solution. That mostly depends on
> the database context, something we can't tell. And according to how much
> you agree to lose (one minute of activity? one hour?), you then can
> choose between pg_dump or PITR backups.
>
> But with a 1TB-database, I wouldn't dare using pg_dump. PITR backup is
> the only option.
>
>
> --
> Guillaume Lelarge
> Consultant
> https://dalibo.com
>
>
>

--000000000000239da30630dac888
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Thank you everyone!</div><br><div class=3D"gmail_quote gma=
il_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Fri, Mar 21, 2=
025 at 7:23=E2=80=AFPM Guillaume Lelarge &lt;<a href=3D"mailto:guillaume.le=
large@dalibo.com">guillaume.lelarge@dalibo.com</a>&gt; wrote:<br></div><blo=
ckquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left=
:1px solid rgb(204,204,204);padding-left:1ex">On 20/03/2025 15:04, Adrian K=
laver wrote:<br>
&gt; On 3/20/25 05:58, Siraj G wrote:<br>
&gt;&gt; Hello Laurenz<br>
&gt;&gt;<br>
&gt;&gt; As per my understanding coming to a proper conclusion wrt RPO <br>
&gt; <br>
&gt; You still have not defined what RPO is.<br>
&gt; <br>
<br>
I guess the OP is talking about Recovery Point Objective, which is one <br>
of two important parameters WRT to disaster recovery. It&#39;s the maximum =
<br>
data loss you agree on with your backup solution. That mostly depends on <b=
r>
the database context, something we can&#39;t tell. And according to how muc=
h <br>
you agree to lose (one minute of activity? one hour?), you then can <br>
choose between pg_dump or PITR backups.<br>
<br>
But with a 1TB-database, I wouldn&#39;t dare using pg_dump. PITR backup is =
<br>
the only option.<br>
<br>
<br>
-- <br>
Guillaume Lelarge<br>
Consultant<br>
<a href=3D"https://dalibo.com" rel=3D"noreferrer" target=3D"_blank">https:/=
/dalibo.com</a><br>
<br>
<br>
</blockquote></div>

--000000000000239da30630dac888--