DB wal file disabled --_Query

From: jayakumar s <kumardba27(dot)postgresql(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: DB wal file disabled --_Query
Date: 2024-11-13 16:15:49
Message-ID: CAFPcKG3hvKngtHg_Dy8_1Cq7zJhjcz_YRH-pfnSW4F1jeV5NNQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)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(at)# pg_wal]$

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2024-11-13 16:21:44 Re: DB wal file disabled --_Query
Previous Message celati Laurent 2024-11-13 14:58:21 Extract values from XML content