Have you tried
archive_command='/bin/true'
as Andreas wrote?
-Original Message-
From: Stefan Petrea [mailto:stefan.pet...@tangoe.com]
Sent: Wednesday, January 24, 2018 2:48 PM
To: pgsql-performa...@postgresql.org
Subject: pg_xlog unbounded growth
Hello,
This email is str
Hi,
Am 24.01.2018 um 12:48 schrieb Stefan Petrea:
We're using PostgreSQL 9.6.6 on a Ubuntu 16.04.3 LTS.
During some database imports(using pg_restore), we're noticing fast
and unbounded growth of pg_xlog up to the point where the
partition(280G in size for us) that stores it fills up and Postgr
On 01/24/2018 12:48 PM, Stefan Petrea wrote:
> Hello,
>
> This email is structured in sections as follows:
>
> 1 - Estimating the size of pg_xlog depending on postgresql.conf parameters
> 2 - Cleaning up pg_xlog using a watchdog script
> 3 - Mailing list survey of related bugs
> 4 - Thoughts
>
Stefan Petrea wrote:
> During some database imports(using pg_restore), we're noticing fast
> and unbounded growth of pg_xlog up to the point where the
> partition(280G in size for us) that stores it fills up and PostgreSQL
> shuts down.
What do you see in pg_stat_archiver?
Yours,
Laurenz Albe
growing out of control:
BUG 7902 [7] - Discusses a situation where WAL are produced faster than
checkpoints can be completed(written to disk), and therefore the WALs
in pg_xlog cannot be recycled/deleted. The status of this bug report
is unclear. I have a feeling it's still open. Is that
