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 <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1t6SXX-00D88D-Li
	for pgsql-general@arkaria.postgresql.org; Thu, 31 Oct 2024 10:36:31 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1t6SXV-00HXGy-Ud
	for pgsql-general@arkaria.postgresql.org; Thu, 31 Oct 2024 10:36:30 +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 <paulbrindusa88@gmail.com>)
	id 1t6SXV-00HXF4-H9
	for pgsql-general@lists.postgresql.org; Thu, 31 Oct 2024 10:36:29 +0000
Received: from mail-ej1-x632.google.com ([2a00:1450:4864:20::632])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <paulbrindusa88@gmail.com>)
	id 1t6SXT-003yuE-NL
	for pgsql-general@postgresql.org; Thu, 31 Oct 2024 10:36:29 +0000
Received: by mail-ej1-x632.google.com with SMTP id a640c23a62f3a-a9a628b68a7so108096066b.2
        for <pgsql-general@postgresql.org>; Thu, 31 Oct 2024 03:36:27 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1730370986; x=1730975786; darn=postgresql.org;
        h=to:subject:message-id:date:from:mime-version:from:to:cc:subject
         :date:message-id:reply-to;
        bh=El9AHBV1ACLDTDzWqwuyx3I8dreFeo+kflTWcMJMYps=;
        b=NBWXLHBC+B6gQKbuLSRuJlXcQXARFtF6E6495S8pTDDnpRnPX6yBnITpHucNjHDhNP
         yHuRJgbn24dfGc4ZegWwl63vlk2uBraPpojmrGR4wkirsJJ/0leSFiIfzw9MbrPQgolq
         5JJzZQcDooTh/lAOWsjvrTOVdurCAk1Q/ezS8KNTnTLe3fKgXn9lSyCMvV6pg5xFHtjR
         En8mpTyNhnNUeB9uKpho/kKwKeNY8RuXTJDNOY9AXWhFWuXt37Vf7SpvEKqlHOfYswL6
         2zfkXOC2e2XnTP3kGjnNCV+mZniYXgfuYXMV5PhjaYp7ta/PivDIdZOFBEBN3nchV0oX
         lCOw==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1730370986; x=1730975786;
        h=to:subject:message-id:date:from:mime-version:x-gm-message-state
         :from:to:cc:subject:date:message-id:reply-to;
        bh=El9AHBV1ACLDTDzWqwuyx3I8dreFeo+kflTWcMJMYps=;
        b=QsJQR6w4OZGz2JzhlmctPEhy5Y7f72+XAdh9OHIkmx6kDr/8wIcLGZQMCvlmwIi5sZ
         z3KuznS3hBhKqQfMPZhBLG/+MnWD8+odHzCCXjm1E60gxiHeZcXoTSHmauCAra11cMmw
         8vG7WaDh0+ChT9QwLPNth7NJv+YdOJ1jjhAPOmg7vdeM/QkPa0wO9RRbRajIF/Sa9zYI
         RBEUBSDhKku8+YtZDzIoTO7De95nQpVocEKQRZpSf0nYOyqu5FjZsHlnyqHS+nZaDQFy
         1uyr4Zid0Fcq26QSffLJ8FoIUKedoOcxEUxO/8lpWhgBLfkACmFxCXo9McQeYiVTR7hX
         AwSA==
X-Gm-Message-State: AOJu0YylI6Hg+mYyO47hcGWz5WVg27aT+7QUapgo0R8CH1OgaAKOxm7u
	FAOgVfDOQSxGqu5iwfliQUjVKY6mhCd3AhsAec0owMvOv4t02sM6RN7Sc3N4aALXZNGF3US8fw9
	JLzBg9qyB6qj5zrGLgbX0jJLnqVznkA==
X-Google-Smtp-Source: AGHT+IEWnDDbjeNX9Z3CLFUsT2ApkekUtEesFsBe5eEsd13QbA345mkR7ymxl978NTugdt/D3MfsY90crpGYAEjdxRc=
X-Received: by 2002:a17:907:e92:b0:a87:31c:c6c4 with SMTP id
 a640c23a62f3a-a9de5d9e1f6mr1627738266b.24.1730370985492; Thu, 31 Oct 2024
 03:36:25 -0700 (PDT)
MIME-Version: 1.0
From: Paul Brindusa <paulbrindusa88@gmail.com>
Date: Thu, 31 Oct 2024 10:36:14 +0000
Message-ID: <CAFeSbqjySUzp_Q4XNR_ajnV84O=om0f5rzpjPsQaNitDkxXjHw@mail.gmail.com>
Subject: pg_wal folder high disk usage
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000eb87660625c36367"
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/CAFeSbqjySUzp_Q4XNR_ajnV84O%3Dom0f5rzpjPsQaNitDkxXjHw%40mail.gmail.com>
Precedence: bulk

--000000000000eb87660625c36367
Content-Type: text/plain; charset="UTF-8"

Good morning,

On one of our postgres instances we have the pg_wal/data folder up to
196GB, out of 200GB disk filled up.
This has stopped the posgresql.service this morning causing two
applications to crash.
Unfortunately our database admin is on leave today, and we are trying to
figure out how to get the disk down?
Any ideas or suggestions are more than welcome.

Thank you in advance.

-- 
Kind Regards,
Paul Brindusa
paulbrindusa88@gmail.com

--000000000000eb87660625c36367
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Good morning,</div><div><br></div><div>On one of our =
postgres instances we have the pg_wal/data folder up to 196GB, out of 200GB=
 disk filled up.</div><div>This has stopped the posgresql.service this morn=
ing causing two applications to crash.</div><div>Unfortunately our database=
 admin is on leave today, and we are trying to figure out how to get the di=
sk down?</div><div>Any ideas or suggestions are more than welcome. <br></di=
v><div>=C2=A0<br></div><div>Thank you in advance.<br></div><div><div><div><=
div><div><br><span class=3D"gmail_signature_prefix">-- </span><br><div dir=
=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div =
dir=3D"ltr"><div>Kind Regards,</div><div>Paul Brindusa</div><div><a href=3D=
"mailto:paulbrindusa88@gmail.com" target=3D"_blank">paulbrindusa88@gmail.co=
m</a></div><div><br></div></div></div></div></div></div></div></div></div>

--000000000000eb87660625c36367--