MIME-Version: 1.0
References: <CAFPcKG3hvKngtHg_Dy8_1Cq7zJhjcz_YRH-pfnSW4F1jeV5NNQ@mail.gmail.com>
In-Reply-To: <CAFPcKG3hvKngtHg_Dy8_1Cq7zJhjcz_YRH-pfnSW4F1jeV5NNQ@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Wed, 13 Nov 2024 09:21:44 -0700
Message-ID: <CAKFQuwZyrYz4=9QjZk3VQa99vogagqTr1_ueLxft1u-hd_86Mg@mail.gmail.com>
Subject: Re: DB wal file disabled --_Query
To: jayakumar s <kumardba27.postgresql@gmail.com>
Cc: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000065cbc0626cdbd1a"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwZyrYz4%3D9QjZk3VQa99vogagqTr1_ueLxft1u-hd_86Mg%40mail.gmail.com>
Precedence: bulk

--000000000000065cbc0626cdbd1a
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, Nov 13, 2024 at 9:16=E2=80=AFAM jayakumar s <kumardba27.postgresql@=
gmail.com>
wrote:

> postgres=3D# select name,setting from pg_settings where name like 'archiv=
e%';
>       name       |  setting
> -----------------+------------
>  archive_command | (disabled)
>

You cannot disable WAL.  What is disabled here is copying the WAL that is
produced to an archive.  IOW, backing up WAL.

David J.

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

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Wed, Nov 13, 2024 at 9:16=E2=80=AFAM jayakumar s &lt;<a=
 href=3D"mailto:kumardba27.postgresql@gmail.com">kumardba27.postgresql@gmai=
l.com</a>&gt; wrote:</span></div></div><div class=3D"gmail_quote"><blockquo=
te class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px =
solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div>postgres=3D#=
 select name,setting from pg_settings where name like &#39;archive%&#39;;</=
div>=C2=A0 =C2=A0 =C2=A0 name =C2=A0 =C2=A0 =C2=A0 | =C2=A0setting<br>-----=
------------+------------<br>=C2=A0archive_command | (disabled)<br></div></=
blockquote><div><br></div><div class=3D"gmail_default" style=3D"font-family=
:arial,helvetica,sans-serif">You cannot disable WAL.=C2=A0 What is disabled=
 here is copying the WAL that is produced to an archive.=C2=A0 IOW, backing=
 up WAL.</div><div class=3D"gmail_default" style=3D"font-family:arial,helve=
tica,sans-serif"><br></div><div class=3D"gmail_default" style=3D"font-famil=
y:arial,helvetica,sans-serif">David J.</div><div class=3D"gmail_default" st=
yle=3D"font-family:arial,helvetica,sans-serif"><br></div><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex">
</blockquote></div></div>

--000000000000065cbc0626cdbd1a--