Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vxQaW-00DWak-2I for pgsql-general@arkaria.postgresql.org; Tue, 03 Mar 2026 14:19:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vxQaU-007EZJ-0w for pgsql-general@arkaria.postgresql.org; Tue, 03 Mar 2026 14:19:02 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vxQaT-007EZA-36 for pgsql-general@lists.postgresql.org; Tue, 03 Mar 2026 14:19:02 +0000 Received: from mail-ej1-x629.google.com ([2a00:1450:4864:20::629]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vxQaS-00000000Bmt-2MmQ for pgsql-general@lists.postgresql.org; Tue, 03 Mar 2026 14:19:01 +0000 Received: by mail-ej1-x629.google.com with SMTP id a640c23a62f3a-b932fe2e1a7so783175666b.1 for ; Tue, 03 Mar 2026 06:19:00 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1772547538; cv=none; d=google.com; s=arc-20240605; b=ghs4j/CjvpRYXKylS1HpINtRvehDg4bZMnkrkx9WlobOwixeNlPLD/GNaatMGZJKJj MHrk3IrINfHyI4XV8CFDxB2S13arwhoXonDla6VwOfIqabEHBK9GvvddCObI5MYwAg6R kXExIikTK3HZuQPgkEobfsoS+oFoGLTvpiZ76T1GKFHOzsHPNowTHMMCjZhiNTZ6MIL4 f3eKXLf7V6YkTeEqDOHPMYw8qqnMaaXMikWx/ymzrCGz1fy6kusMngI8Ms/NhLhBkdBp +v3OUXKn3oaC3mLC1wjmhoDhxB10fNkVGhMiOFjUPO9qj5wSTmVS2LCjLG9byllOevam FUpw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:mime-version:dkim-signature; bh=JLztNDOuUi4l1IAnHgpu7k7XQPet5bjtPw3kVxtR+rw=; fh=nxmC7ZFS331lEy6Uerbqjx/p9ZRj8cOgWjVDqfOv5zs=; b=ZmXuc9NgK7cEOeSkzxEyNGBHfACpfwSqJPqXQPIJaClZVjT5q/bcu03Y5I+19UuoZl Xt4yuNuyOp4PL/AfjTZOGae5FZbS49fZo3mP7u0WqKGzQhHBTcRbIhc0LmlBM45hQ/Lw abFFierEGXWSI8n7OV8Q4WvfXHK8C/9LI1EJYe0tjoLahOPp+h6LgM0AqJJ9Uie4gLE3 Ia9mlLYwMDIxt8mrQnnyO/+APRG4O1UfN58VqNH7NQL1Cg1Yv0EA10Xe7WYz2sHkOhFd DYwbhJqCjOp1KehPjGfbT+NeStRBIeElTgJlGlR2xSLKlBt+klvWWs5Hl1pK2aNMIAT7 BizQ==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1772547538; x=1773152338; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=JLztNDOuUi4l1IAnHgpu7k7XQPet5bjtPw3kVxtR+rw=; b=JvwTyaznaJvM1bZXl0Qj58W4l0nTTxqF0fbWDjSLKelvBbcYXGmwB2Di115Z+498yL o2XQU/6YSXKszsKV0uEbbRu5n1RvzjDbUX63imFYqNGwkkm4u/DVFqCVY/erHI/BFS/6 03rG9jWTyul/IrMv4OzUUB7issnbElViizSc15KlrWTDuk+AZzh7eqwxs//vAs1cqcs9 EgpbbVCBPmLW80HCe0umymgG+6O9dD032fahpsM/FvWzbQ0Aj3rEr5sc4WiZNESgujyT 9P1eB0vZ3bHuRm3aNgGILt7uS1OP3AXv5LRgpHiNTxMPD9Byt4KOkxd3TnBg1pMqpSYQ e90w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772547538; x=1773152338; h=cc:to:subject:message-id:date:from:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=JLztNDOuUi4l1IAnHgpu7k7XQPet5bjtPw3kVxtR+rw=; b=G8Jzr6siLvIAyiM14hoFtQgDqVNdneFIA5MIKn3KKlmo9w/r6THpOiYeZH0wpErdHI E0enJdXsguwZYNL6au2QZclil95onOsK/hV4h6RCxjRMzajL8yEzsVz8w2fCvknNmnpT goMmtapjvlgXGGJOSxRqgcTjmYN9QHj5EQFzaU2ot6yhEzpKSrwAwy2RE8hz7BLSEEA5 b6zYrJNyPdLH2CaG7q+d/9sRP+8Yjxmr0N1i1Nsz+cn/P6Y5HT7maVSaugSUZeOI67De I+H5M+THKe569iqP24BqHz6wUyyWgtblDjXeDAaamgU5gJMsbyBVzQpe/15/kU22gpn3 rnHQ== X-Gm-Message-State: AOJu0Ywd3635iBbPzS7SadiwSBd7cGyo9xejhzTSxzM2zbBXYnoaVfd0 BGGEP2kHOpqcF0fDSfcaWDKu6JmGcZ9sb5uGlhsl/Bsjltax64R3NCvxJj61CcuVeCJrcGlHnzZ tIZl5Tpfj2lzM7nVr2yUjJUH7A4GXaDU6442WIDk= X-Gm-Gg: ATEYQzynPTm6Ca6JoT9ShjbvmOrazI9dIgeuPELBgJjwScps62wh2GkoI87UUtnVxNk NPt2AmjvUOzvwJI6aCbmW66J0a8OJtnrf25ZzYsE51jK06/2zfT7pV7Y5+JaWY7YcX7PRP3UbV7 34eyzfF/6bOadJCP3e5HbvfcZUprV9pfDs6mohotss11eJjUTojxu707qdrqqjt0Mc8ZEZFe/A4 +kdKFwwkikv/jsbCqTbTDvsPatGrMDmQ44WmhNvkDOQCZw22f+yjmFp4obfumwwRLKelE2DkA17 l5M8ZTo= X-Received: by 2002:a17:907:6d0c:b0:b8f:a85c:95c5 with SMTP id a640c23a62f3a-b93764ecb37mr1000017366b.37.1772547537926; Tue, 03 Mar 2026 06:18:57 -0800 (PST) MIME-Version: 1.0 From: loganathan P Date: Tue, 3 Mar 2026 19:51:31 +0530 X-Gm-Features: AaiRm51C9YfQwejlJZ-UN3j5vGvh3U3ldvsX0R63v6kbZM-1Is8NBBY6rvao1rc Message-ID: Subject: =?UTF-8?Q?PostgreSQL_Archive_Log_Partition_Reaching_95=25_=E2=80=93_Ne?= =?UTF-8?Q?ed_Automated_Cleanup?= To: pgsql-general@lists.postgresql.org Cc: loganathan P Content-Type: multipart/alternative; boundary="000000000000587ed6064c1f626b" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000587ed6064c1f626b Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Dear Team, We have PostgreSQL 15 and PostgreSQL 17 databases running in separate environments on different servers. Each database is approximately 1.5 TB in size and highly active, generating around 500 GB of archive logs per day. We have VM SRM replication configured. The archive log partition reaches 95=E2=80=93100% utilization before backup= s are taken. After the backups are completed, we must manually remove the archived log files to free up space. Could you please advise whether PostgreSQL has any built-in parameters or mechanisms to automatically delete archived log files once they have been successfully backed up? Thanks. Regards, Loganathan P --000000000000587ed6064c1f626b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Dear Team,

We have PostgreSQ= L 15 and PostgreSQL 17 databases running in separate environments on differ= ent servers. Each database is approximately 1.5 TB in size and highly activ= e, generating around 500 GB of archive logs per day. We have VM SRM replica= tion configured.

The archive log partition reaches 95=E2=80=93100% u= tilization before backups are taken. After the backups are completed, we mu= st manually remove the archived log files to free up space.

Could yo= u please advise whether PostgreSQL has any built-in parameters or mechanism= s to automatically delete archived log files once they have been successful= ly backed up?



Thanks.

Regar= ds,
Loganathan P
--000000000000587ed6064c1f626b--