On Tue, 19 Jul 2022, 2:09 am Alan Hodgson, <ahodg...@lists.simkin.ca> wrote:
> On Mon, 2022-07-18 at 15:55 -0400, neslişah demirci wrote: > > Hi all, > > > > Wondering if anyone has any experience of using pg_receivewal/xlog > > to ship wal files to GCP/S3? > > > > I use archive_command to send WAL to S3. It works fine. I do gzip > them before uploading, as they are usually pretty compressible. > > I use a lifecycle rule on the bucket to automatically delete ones > older than I might need. > > It's not the fastest process in the world, and replay on our > reporting server does occasionally fall behind, but I think that's > true of WAL replay in general as a serialized process. > Have a look at this also. https://supabase.com/blog/2020/08/02/continuous-postgresql-backup-walg
