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