Message-ID: <f2fbd780-f0c1-4aac-b136-913da043e82c@dalibo.com>
Date: Fri, 21 Mar 2025 14:52:55 +0100
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Export operation efficiency in read replica
To: pgsql-general@lists.postgresql.org
References: <CAC5iy60ZzcsxL1GKAdUdiqA7TFv_yQW3ZkN07VJM8J1Xkdk8Gg@mail.gmail.com>
 <e5e1bd6610da84292deb7ba0a3196b66f0b1bef7.camel@cybertec.at>
 <CAC5iy60NgOv2nRYNwSh2n-Pj82eUjghgWjV2VCuQUABsAZ9uiw@mail.gmail.com>
 <143af5f7-94c1-453b-803e-12f162780a83@aklaver.com>
Content-Language: fr
From: Guillaume Lelarge <guillaume.lelarge@dalibo.com>
Organization: Dalibo
In-Reply-To: <143af5f7-94c1-453b-803e-12f162780a83@aklaver.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/f2fbd780-f0c1-4aac-b136-913da043e82c%40dalibo.com>
Precedence: bulk

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