Re: Export operation efficiency in read replica

From: Siraj G <tosiraj(dot)g(at)gmail(dot)com>
To: Guillaume Lelarge <guillaume(dot)lelarge(at)dalibo(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Export operation efficiency in read replica
Date: 2025-03-21 14:07:46
Message-ID: CAC5iy63orsh6axhJEtQGOs4qTHbnqTFrsj12SZx8MRgaJovyWw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thank you everyone!

On Fri, Mar 21, 2025 at 7:23 PM Guillaume Lelarge <
guillaume(dot)lelarge(at)dalibo(dot)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
>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Cosimo Simeone 2025-03-21 14:48:56 Re: Need help understanding has_function_privilege
Previous Message Guillaume Lelarge 2025-03-21 13:52:55 Re: Export operation efficiency in read replica