MIME-Version: 1.0
From: jayakumar s <kumardba27.postgresql@gmail.com>
Date: Wed, 13 Nov 2024 21:45:49 +0530
Message-ID: <CAFPcKG3hvKngtHg_Dy8_1Cq7zJhjcz_YRH-pfnSW4F1jeV5NNQ@mail.gmail.com>
Subject: DB wal file disabled --_Query
To: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="0000000000004bfd290626cda6d8"
Archived-At: <https://www.postgresql.org/message-id/CAFPcKG3hvKngtHg_Dy8_1Cq7zJhjcz_YRH-pfnSW4F1jeV5NNQ%40mail.gmail.com>
Precedence: bulk

--0000000000004bfd290626cda6d8
Content-Type: text/plain; charset="UTF-8"

Hi Team,

We have disabled walfile ion database level. While I do manual switch wal
file generating in wal file location.

Here is my question if we disable it. Walfile won't generate am i correct?

Kindly clarify my doubts.

postgres=# select name,setting from pg_settings where name like 'archive%';
      name       |  setting
-----------------+------------
 archive_command | (disabled)
 archive_mode    | off
 archive_timeout | 0
(3 rows)

postgres=#

postgres=# SELECT pg_switch_wal();
 pg_switch_wal
---------------
 D/9D000000
(1 row)

[postgres@xxxxxxxxx pg_wal]$ ls -lrt
total 81920
drwx------. 2 postgres postgres        6 Oct 13  2020 archive_status
-rw-------. 1 postgres postgres 16777216 Nov 13 20:47
000000010000000D0000009F
-rw-------. 1 postgres postgres 16777216 Nov 13 20:50
000000010000000D000000A0
-rw-------. 1 postgres postgres 16777216 Nov 13 20:51
000000010000000D000000A1
-rw-------. 1 postgres postgres 16777216 Nov 13 21:02
000000010000000D0000009D
-rw-------. 1 postgres postgres 16777216 Nov 13 21:02
000000010000000D0000009E
[postgres@# pg_wal]$

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

<div dir=3D"ltr"><div>Hi Team,</div><div><br></div><div>We have disabled wa=
lfile ion database level. While I do manual switch wal file generating in w=
al file location.</div><div><br></div><div>Here is my question if we disabl=
e it. Walfile won&#39;t generate am i correct?</div><div><br></div><div>Kin=
dly clarify my doubts.<br></div><div><br></div><div>postgres=3D# select nam=
e,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>=C2=A0archive_mode =
=C2=A0 =C2=A0| off<br>=C2=A0archive_timeout | 0<br>(3 rows)<br><br><div>pos=
tgres=3D# <br></div><div><br></div><div>postgres=3D# SELECT pg_switch_wal()=
;<br>=C2=A0pg_switch_wal<br>---------------<br>=C2=A0D/9D000000<br>(1 row)<=
/div><div><br></div><div>[postgres@xxxxxxxxx pg_wal]$ ls -lrt<br>total 8192=
0<br>drwx------. 2 postgres postgres =C2=A0 =C2=A0 =C2=A0 =C2=A06 Oct 13 =
=C2=A02020 archive_status<br>-rw-------. 1 postgres postgres 16777216 Nov 1=
3 20:47 000000010000000D0000009F<br>-rw-------. 1 postgres postgres 1677721=
6 Nov 13 20:50 000000010000000D000000A0<br>-rw-------. 1 postgres postgres =
16777216 Nov 13 20:51 000000010000000D000000A1<br>-rw-------. 1 postgres po=
stgres 16777216 Nov 13 21:02 000000010000000D0000009D<br>-rw-------. 1 post=
gres postgres 16777216 Nov 13 21:02 000000010000000D0000009E<br>[postgres@#=
 pg_wal]$</div></div>

--0000000000004bfd290626cda6d8--