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