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 | CAEHH7R7vxmAQjBYz89uVr76HsFLiXC8P2EHU4_+7mr1f4Qfa_A@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: BUG #14963: Number of wal files are keep on increasing ("David G. Johnston" <david.g.johnston@gmail.com>) |
| Ответы |
Re: BUG #14963: Number of wal files are keep on increasing
|
| Список | pgsql-bugs |
Hi David,
We are using pg_basebackup to take the backup of the database. The version of PostgreSQL is 9.2.9. My Postgres database configs are as below.
wal_buffers = 16MB
max_wal_senders = 1
wal_level = archive
archive_mode = on
checkpoint_segments = 50
wal_keep_segments = 80
checkpoint_completion_target = 0.9
synchronous_commit = on
Do we have any command to minimize the wall files. Day by day number of wal files are increasing due to that slowly disk will be full.
Regards,
Raghavendra Rao
On Mon, Dec 11, 2017 at 8:06 PM, David G. Johnston <david.g.johnston@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 = 80This 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.
Regards,
Raghavendra Rao J S V
Mobile- 8861161425
Raghavendra Rao J S V
Mobile- 8861161425
В списке pgsql-bugs по дате отправления: