DB wal file disabled --_Query
От | jayakumar s |
---|---|
Тема | DB wal file disabled --_Query |
Дата | |
Msg-id | CAFPcKG3hvKngtHg_Dy8_1Cq7zJhjcz_YRH-pfnSW4F1jeV5NNQ@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: DB wal file disabled --_Query
Re: DB wal file disabled --_Query |
Список | 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)
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]$
В списке pgsql-general по дате отправления: