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.94.2) (envelope-from ) id 1tlQcp-00Bv5h-Te for pgsql-bugs@arkaria.postgresql.org; Fri, 21 Feb 2025 10:51:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tlQco-007EK8-85 for pgsql-bugs@arkaria.postgresql.org; Fri, 21 Feb 2025 10:51:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tlQcn-007EK0-Vk for pgsql-bugs@lists.postgresql.org; Fri, 21 Feb 2025 10:51:18 +0000 Received: from lana.depesz.com ([88.198.49.178] helo=depesz.com) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tlQcl-0028WO-2j for pgsql-bugs@lists.postgresql.org; Fri, 21 Feb 2025 10:51:17 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=depesz.com; s=20170201; h=In-Reply-To:Content-Type:MIME-Version:References:Reply-To: Message-ID:Subject:To:Sender:From:Date:Cc:Content-Transfer-Encoding: Content-ID:Content-Description; bh=pmrWYEJ6fHYGlqfhOdURxbTUYmT8GgeZ5K0uT8K9RGk=; b=budgvA674DDwbXhOkwqaEa+W4j uYyrJ4s8s5SqVKFmhTH05uC2r2xKXPtjm3Z0IzMXHGLXN5hpPRS3R48FjXeoBsK3WxzIPjBIAt9fV uhHONXj5rFk/KdcHfDpzgnD2bmhP0360S5GDtt0ZMednDSdCExKGKFP17HAa4j9Q2X2Q=; Received: from depesz by depesz.com with local (Exim 4.96) (envelope-from ) id 1tlQck-000Nhb-1T; Fri, 21 Feb 2025 11:51:14 +0100 Date: Fri, 21 Feb 2025 11:51:14 +0100 From: hubert depesz lubaczewski Sender: depesz@depesz.com To: marle.saransig@gmail.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #18821: Need delete files in pg_wal, size is bigger overcome limit max_wal_size Message-ID: Reply-To: depesz@depesz.com References: <18821-fd87033e4102cf03@postgresql.org> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <18821-fd87033e4102cf03@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Feb 20, 2025 at 05:42:40PM +0000, PG Bug reporting form wrote: > The following bug has been logged on the website: > > Bug reference: 18821 > Logged by: Marlene Saransig > Email address: marle.saransig@gmail.com > PostgreSQL version: 15.2 > Operating system: Alma Linux 9.1 > Description: > > Need to eliminate files of /var/lib/pgsql/15/data/pg_wal/, because overcome > limit define in max_wal_size and this increase size used in hard disk You might want to read https://www.depesz.com/2023/06/18/why-is-my-wal-directory-so-large/ Generally, it's extremely unlikely to be a bug in postgresql. More likely misconfiguration or forgotten "thing" that is causing the issue. Best regards, depesz