Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bjQjR-0005ZA-6i for pgsql-admin@arkaria.postgresql.org; Mon, 12 Sep 2016 12:53:05 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bjQjQ-0005H6-PU for pgsql-admin@arkaria.postgresql.org; Mon, 12 Sep 2016 12:53:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bjQjP-0005GU-VV for pgsql-admin@postgresql.org; Mon, 12 Sep 2016 12:53:04 +0000 Received: from imx6.etecsa.cu ([200.55.152.141]) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bjQjN-00033X-CM for pgsql-admin@postgresql.org; Mon, 12 Sep 2016 12:53:03 +0000 Received: from nodo1.etecsa.cu (unknown [192.168.91.200]) by imx6.etecsa.cu (Postfix) with ESMTP id DE4D83B7; Mon, 12 Sep 2016 08:52:59 -0400 (CDT) Received: from webmail.etecsa.cu (unknown [192.168.91.6]) by nodo1.etecsa.cu (Postfix) with ESMTP id BFC0732060A3; Mon, 12 Sep 2016 08:52:59 -0400 (CDT) Received: from 192.168.207.54 (SquirrelMail authenticated user gilberto.castillo) by webmail.etecsa.cu with HTTP; Mon, 12 Sep 2016 08:51:58 -0500 (GMT+5) Message-ID: <57728.192.168.207.54.1473688318.squirrel@webmail.etecsa.cu> In-Reply-To: <1473683682585-5920762.post@n3.nabble.com> References: <1473683682585-5920762.post@n3.nabble.com> Date: Mon, 12 Sep 2016 08:51:58 -0500 (GMT+5) Subject: Re: [MASSMAIL]My pg_xlog directory is becoming huge !? From: "Gilberto Castillo" To: "ben.play" Cc: pgsql-admin@postgresql.org Reply-To: gilberto.castillo@etecsa.cu User-Agent: SquirrelMail/1.4.8-5.el5_4.10 MIME-Version: 1.0 Content-Type: text/plain;charset=utf-8 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-KLMS-Rule-ID: 1 X-KLMS-Message-Action: clean X-KLMS-AntiSpam-Lua-Profiles: 102559 [Sep 12 2016] X-KLMS-AntiSpam-Version: 5.6.0.28 X-KLMS-AntiSpam-Envelope-From: gilberto.castillo@etecsa.cu X-KLMS-AntiSpam-Rate: 0 X-KLMS-AntiSpam-Status: not_detected X-KLMS-AntiSpam-Method: none X-KLMS-AntiSpam-Info: LuaCore: 105 105 f574bfb6167b9d46a003d24cdc2e133abf98ebd1, {msgid_created_by_recepient}, Auth:dkim=none X-KLMS-AntiSpam-Interceptor-Info: scan successful X-KLMS-AntiPhishing: Clean, 2016/09/09 07:18:49 X-KLMS-AntiVirus: Kaspersky Security 8.0 for Linux Mail Server, version 8.0.1.721, bases: 2016/09/12 02:00:00 #8047420 X-KLMS-AntiVirus-Status: Clean, skipped X-Pg-Spam-Score: -3.8 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org > 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 ? What schema type of replication you use? -- Saludos, Gilberto Castillo ETECSA, La Habana, Cuba -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin