Search Postgresql Archives

DB wal file disabled --_Query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux