public inbox for [email protected]  

help / color / mirror / Atom feed

From: jayakumar s <[email protected]>
To: [email protected]
Subject: DB wal file disabled --_Query
Date: Wed, 13 Nov 2024 21:45:49 +0530
Message-ID: <CAFPcKG3hvKngtHg_Dy8_1Cq7zJhjcz_YRH-pfnSW4F1jeV5NNQ@mail.gmail.com> (raw)

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]$

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: DB wal file disabled --_Query
  In-Reply-To: <CAFPcKG3hvKngtHg_Dy8_1Cq7zJhjcz_YRH-pfnSW4F1jeV5NNQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox