Re: BUG #14963: Number of wal files are keep on increasing

Поиск
Список
Период
Сортировка
От Raghavendra Rao J S V
Тема Re: BUG #14963: Number of wal files are keep on increasing
Дата
Msg-id CAEHH7R7=fuZXxMeAa-x_4-3P8Z95=BbkDP-LSam1r2RwsYZ2dQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #14963: Number of wal files are keep on increasing  (Sergei Kornilov <sk@zsrv.org>)
Ответы Re: BUG #14963: Number of wal files are keep on increasing  (Sergei Kornilov <sk@zsrv.org>)
Список pgsql-bugs
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 по дате отправления:

Предыдущее
От: Sergei Kornilov
Дата:
Сообщение: Re: BUG #14963: Number of wal files are keep on increasing
Следующее
От: Sergei Kornilov
Дата:
Сообщение: Re: BUG #14963: Number of wal files are keep on increasing