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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #14963: Number of wal files are keep on increasing
Дата
Msg-id CAKFQuwawUOnNGRXdJGX5dgQ71hdY8MAfxzPW=1deJ1z8FS=u5Q@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #14963: Number of wal files are keep on increasing  (raghavendrajsv@gmail.com)
Ответы Re: BUG #14963: Number of wal files are keep on increasing  (Raghavendra Rao J S V <raghavendrajsv@gmail.com>)
Список pgsql-bugs
On Mon, Dec 11, 2017 at 7:18 AM, <raghavendrajsv@gmail.com> wrote:
The following bug has been logged on the website:

Bug reference:      14963
Logged by:          Raghav Rao
Email address:      raghavendrajsv@gmail.com
PostgreSQL version: Unsupported/Unknown
Operating system:   Centos
Description:

pg_xlog file the log files are keep on increasing day by day. Due to this
disk is full unable to proceed further. Please help me.

checkpoint_segments = 50
wal_keep_segments = 8
​0

This is not a bug report.  Please use "pgsql-general@lists.postgresql.org" for usage assistance requests.  Stating your version and describing what kinds of backups you are performing are necessary for help on this topic.

If you have limited drive space the choice of 80 for "wal_keep_segments" in not advisable - though it is only a minimum and if your backup routine is not working properly the behavior you are seeing can result.

David J.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: digoal@126.com
Дата:
Сообщение: BUG #14964: statement_timeout cann't set in plpgsql
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #14964: statement_timeout cann't set in plpgsql