Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #14963: Number of wal files are keep on increasing - Mailing list pgsql-bugs

From Raghavendra Rao J S V
Subject Re: BUG #14963: Number of wal files are keep on increasing
Date
Msg-id CAEHH7R7=fuZXxMeAa-x_4-3P8Z95=BbkDP-LSam1r2RwsYZ2dQ@mail.gmail.com
Whole thread Raw
In response to Re: BUG #14963: Number of wal files are keep on increasing  (Sergei Kornilov <sk@zsrv.org>)
Responses Re: BUG #14963: Number of wal files are keep on increasing  (Sergei Kornilov <sk@zsrv.org>)
List pgsql-bugs
Tree view
Hi Sergie/David,

archive_command and archive_timeout values are as below in configuration file. 

#archive_command = '' # command to use to archive a logfile segment
# placeholders: %p = path of file to archive
#               %f = file name only
# e.g. 'test ! -f /mnt/server/archivedir/%f && cp %p /mnt/server/archivedir/%f'
#archive_timeout = 0 # force a logfile segment switch after this
# number of seconds; 0 disables

Below error is there in several times in log file.

WARNING,01000,"archive_mode enabled, yet archive_command is not set",,,,,,,,,""

Please help me what to do and what to set to resolve the same.

Regards,
Raghavendra Rao


On Tue, Dec 12, 2017 at 1:14 PM, Sergei Kornilov <sk@zsrv.org> wrote:
> archive_mode = on
hmm. archive_command was configured according enabled archive_mode? Please show current archive_command value. And try to check postgresql logs, it may contains some number fatal errors "archive command failed with exit code"

regards, Sergei



--
Regards,
Raghavendra Rao J S V
Mobile- 8861161425

pgsql-bugs by date:

Previous
From: Sergei Kornilov
Date:
Subject: Re: BUG #14963: Number of wal files are keep on increasing
Next
From: Sergei Kornilov
Date:
Subject: Re: BUG #14963: Number of wal files are keep on increasing