From: ben.play <benjamin.cohen@playrion.com>
To: pgsql-admin@postgresql.org
Subject: My pg_xlog directory is becoming huge !?
Date: Mon, 12 Sep 2016 05:34:42 -0700 (MST)
Message-ID: <1473683682585-5920762.post@n3.nabble.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi all,
We tried to replicate our database and since this moment, our pg_xlog
directory is becoming HUGE ! (more than 500 Gb !)
In fact, each minute, there is a new file of 16Mb, called like
00000001000001370000004D ...
This is our main parameters in postgresql.conf
The replication is stopped (it was only a test). And I cannot put
wal_level=minimal without having an error at startup.
Do you have any idea to reduce the size of the directory ?
Thank you a lot.
--
View this message in context: http://postgresql.nabble.com/My-pg-xlog-directory-is-becoming-huge-tp5920762.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: benjamin.cohen@playrion.com
Subject: Re: My pg_xlog directory is becoming huge !?
In-Reply-To: <1473683682585-5920762.post@n3.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox