Re: DB wal file disabled --_Query

2024-11-14 Thread David G. Johnston
On Thursday, November 14, 2024, jayakumar s wrote: > > Archive mode is already disabled. If more wal files will generate fs also > reached 100 percent based on application data load. > > As updated archive enabled or disabled. Will any state wall file that > will be generate correct? > WAL files

Re: DB wal file disabled --_Query

2024-11-14 Thread jayakumar s
Hi All, Archive mode is already disabled. If more wal files will generate fs also reached 100 percent based on application data load. As updated archive enabled or disabled. Will any state wall file that will be generate correct? On Wed, Nov 13, 2024 at 9:54 PM Adrian Klaver wrote: > On 11/13/

Re: DB wal file disabled --_Query

2024-11-13 Thread David G. Johnston
On Wed, Nov 13, 2024 at 9:16 AM jayakumar s wrote: > postgres=# select name,setting from pg_settings where name like 'archive%'; > name | setting > -+ > archive_command | (disabled) > You cannot disable WAL. What is disabled here is copying the WAL that

Re: DB wal file disabled --_Query

2024-11-13 Thread Adrian Klaver
On 11/13/24 08:15, jayakumar s wrote: 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

DB wal file disabled --_Query

2024-11-13 Thread jayakumar s
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%