Re: Questions about the continuity of WAL archiving - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Questions about the continuity of WAL archiving
Date
Msg-id bc2198fe-cf6a-47b2-bae9-a694c2097bb3@aklaver.com
Whole thread Raw
In response to Re: Questions about the continuity of WAL archiving  (Bob Jolliffe <bobjolliffe@gmail.com>)
Responses Re: Questions about the continuity of WAL archiving
List pgsql-general
On 8/12/25 10:40, Bob Jolliffe wrote:
> On Tue, 12 Aug 2025 at 17:14, Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.com>> wrote:

>     The solution is to use a more capable storage platform.
> 
> 
> That is an interesting point you make Adrian.  S3 seems quite popular 
> for this type of archiving.  What would you suggest as a more capable 

Yes but from here:

https://pgbackrest.org/user-guide-rhel.html#s3-support

File creation time in S3 is relatively slow so backup/restore 
performance is improved by enabling file bundling.

Where file bundling is explained here:

https://pgbackrest.org/user-guide-rhel.html#backup/bundle

Though I don't think would help in this case.

> (and cost effective) storage platform?

I would say anything that does not use object storage and instead uses 
block storage, so you are not doing the conversion. I have no specific 
recommendations as this is not something I do, archive to the cloud.

> 
> Regards
> Bob
> 
-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Backups with filesystem snapshots
Next
From: px shi
Date:
Subject: Re: Questions about the continuity of WAL archiving