Re: Wal file increase

public inbox for [email protected]  
help / color / mirror / Atom feed

From: kasem adel <[email protected]>
To: Laurenz Albe <[email protected]>
To: pgsql-admin <[email protected]>
Subject: Re: Wal file increase
Date: Mon, 15 Dec 2025 07:25:58 +0000
Message-ID: <AM4P193MB2941220558624561A6A5F6EBAEADA@AM4P193MB2941.EURP193.PROD.OUTLOOK.COM> (raw)
In-Reply-To: <[email protected]>
References: <CAP-pBm9kY6HafeGD-1vrL8UqaQLu2jFJthBjyOsypY=iGJRBxA@mail.gmail.com>
	<[email protected]>

Dear @Laurenz Albe<mailto:[email protected]>,
Thanks for your support We have physical replication connection with Postgres node standby and have another replication slot with logical replication with another node and every day after run pg_basebackup we face huge number of file created and size per every hour is 23GB and in normal size is 0.8 GB and in logical replication we see in logs it’s in same checkpoint but baseline change and we run pg_basebackup with -X fetch -C fast.
Thanks
________________________________
من: Laurenz Albe <[email protected]>
‏‏تم الإرسال: Monday, December 15, 2025 8:31:05 AM
إلى: kasem adel <[email protected]>; pgsql-admin <[email protected]>
‏‏الموضوع: Re: Wal file increase

On Sun, 2025-12-14 at 17:30 +0200, kasem adel wrote:
> Appreciate your usual support that we facing an issue when take pg_basebackup for 4 TB
> database in standby server and when backup finished we face huge number of wal file
> with huge size generated for 6 hours the cause replication interruption.

If you want help with that, you will have to give us enough information to explain what
happened.

- What exactly is a "replication interruption", and how do you diagnose it?

- Are you using streaming replication or logical replication?

- If it is streaming replication, are you using a replication slot?

- It is expected that if you suspend replication and have a replication slot, WAL will
  pile up on the primary.  But what is the connection with pg_basebackup?

Yours,
Laurenz Albe

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Wal file increase
  In-Reply-To: <AM4P193MB2941220558624561A6A5F6EBAEADA@AM4P193MB2941.EURP193.PROD.OUTLOOK.COM>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox