Thank you everyone! On Fri, Mar 21, 2025 at 7:23 PM Guillaume Lelarge < guillaume.lela...@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 > > >
