Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eBoqq-0002RZ-8V for pgsql-admin@arkaria.postgresql.org; Mon, 06 Nov 2017 21:22:36 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1eBoqp-0001A8-RR for pgsql-admin@arkaria.postgresql.org; Mon, 06 Nov 2017 21:22:35 +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 1eBoqp-00017D-8U for pgsql-admin@postgresql.org; Mon, 06 Nov 2017 21:22:35 +0000 Received: from lists.commandprompt.com ([69.168.55.30]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eBoqk-00084v-PW for pgsql-admin@postgresql.org; Mon, 06 Nov 2017 21:22:34 +0000 Received: from [192.168.1.8] (spinlock.commandprompt.com [69.168.55.30]) by lists.commandprompt.com (Postfix) with ESMTPA id DF5DB780; Mon, 6 Nov 2017 13:22:26 -0800 (PST) Received: from c-67-170-3-120.hsd1.wa.comcast.net ([67.170.3.120] helo=[192.168.1.8]) by assp.commandprompt.com with SMTPSA(TLSv1_2 ECDHE-RSA-AES128-GCM-SHA256) (2.5.1); 6 Nov 2017 13:22:26 -0800 Subject: Re: Standby wal issue To: chris kim , pgsql-admin@postgresql.org References: <2e665cd4-da55-ae82-bdb7-c26e7ba91547@propaas.com> From: "Joshua D. Drake" Organization: Command Prompt, Inc. Message-ID: <4bc00717-c926-675f-b826-40f3324ce4fd@commandprompt.com> Date: Mon, 6 Nov 2017 13:22:26 -0800 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.4.0 MIME-Version: 1.0 In-Reply-To: <2e665cd4-da55-ae82-bdb7-c26e7ba91547@propaas.com> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US X-Assp-Version: 2.5.1(16177) on assp.commandprompt.com X-Assp-ID: assp.commandprompt.com m1-03346-04116 X-Assp-Session: 7FBF4D069B10 (mail 1) X-Assp-Original-Subject: Re: [ADMIN] Standby wal issue X-Assp-Client-SSL: yes 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 On 11/06/2017 11:34 AM, chris kim wrote: > Hi Community, > > I have a standby server that is in replication mode only, and is > storing an insane amount of wal files and it's only on the standby not > the master. I have over 50,000 wal files right now. I only have a few > processes running on the background and they all seem to not be the > problem. This is running on postgres 9.2. Any help would be greatly > appreciated. What does your recovery.conf file say? JD > > > Thanks, > > Chris > > > -- Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc PostgreSQL Centered full stack support, consulting and development. Advocate: @amplifypostgres || Learn: https://pgconf.org ***** Unless otherwise stated, opinions are my own. ***** -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin