Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eBnCK-00038k-QX for pgsql-admin@arkaria.postgresql.org; Mon, 06 Nov 2017 19:36:40 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1eBnCJ-0006uG-VA for pgsql-admin@arkaria.postgresql.org; Mon, 06 Nov 2017 19:36:40 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eBnAT-0002Wd-Ek for pgsql-admin@postgresql.org; Mon, 06 Nov 2017 19:34:45 +0000 Received: from mail-it0-x22b.google.com ([2607:f8b0:4001:c0b::22b]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1eBnAQ-0005qs-QB for pgsql-admin@postgresql.org; Mon, 06 Nov 2017 19:34:44 +0000 Received: by mail-it0-x22b.google.com with SMTP id j140so6419587itj.1 for ; Mon, 06 Nov 2017 11:34:42 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=propaas-com.20150623.gappssmtp.com; s=20150623; h=to:from:subject:message-id:date:user-agent:mime-version :content-transfer-encoding:content-language; bh=sYgDnu4kQtNy+67vYOsDDLm3gdTaVqLqiuj75cxSis4=; b=Lr831Mc+c6zQEYGftNapdmt0ZN9BetWIOwTy+s2QFcb1y5K5UyLsHFWIjVzsSuJmPe /KQ9pD8677ZiVB8pugR91iJJSiku8vra9hBc/RfHrUzT2FMsDiwJFvqkdxpa5u4a9LIV irG6tuioVb2aeg6QirjvC58FnOfqeFi9cNVH+YWK6G4SSeA14hWycQc0146+3K1XTU6Q Gf5vzrylNL64K5ebh5RdWNloV74ngFE1BQwWFlPC9d830XQSANhODOO1xzOMZDAw7pEK KMGwf7fRBwKMd0Edxm1JjekxgSy+5m/cqg89veHkJGGSg7AhA+9j0WITJyQ35ydI5Mlx JXRg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:to:from:subject:message-id:date:user-agent :mime-version:content-transfer-encoding:content-language; bh=sYgDnu4kQtNy+67vYOsDDLm3gdTaVqLqiuj75cxSis4=; b=BQV3P0quuJJIyRwiC+2kgbiiqaoTzc4ZuCMxkfKWvto7gKUOiKMEkY1+6PPGcpdgzs sQUZyRrlMQkMlTo/NRSvUeJzGPhSz3KrOca5WfTi55JNyXPe9bj9jWeSs9QFJNZtzbL4 mbR60329mf1G6IEe1v8PaIjQofWvgsGh/KXD/blv8CSrscP5GwNodpmO3Dw45L6XRWJA 7y034Ri4ZcCefFqlnHL3Pn3GAMWvqdZ+bZ3xfDK+Mx0GOaUg5OiDWJPMZ+hSsX9YPyXU QRHng31yJdko14bgFoZRx9kVet5QAV7lfl9f1S5vRlDsYortwPwOjmqu+YggYTAazTjI oo3g== X-Gm-Message-State: AJaThX50/yCGBXUEg0vzECJg6Zid//ELALmD58Pnj9iuR2olT0oheNbv rkVi1IUGJFNzBW4FMo5YQ7ssFhDkFHI= X-Google-Smtp-Source: ABhQp+TO4FkJwwE9w0RdGgepGyGg2pKRQ2I7OirlptV+dABM9iV1nfpolpdu9/UwNF7mpEBFCIYknw== X-Received: by 10.36.107.69 with SMTP id v66mr10615136itc.95.1509996881486; Mon, 06 Nov 2017 11:34:41 -0800 (PST) Received: from ?IPv6:2603:300b:729:7400::8d7d? ([2603:300b:729:7400::8d7d]) by smtp.gmail.com with ESMTPSA id w8sm5991926iod.26.2017.11.06.11.34.40 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 06 Nov 2017 11:34:40 -0800 (PST) To: pgsql-admin@postgresql.org From: chris kim Subject: Standby wal issue Message-ID: <2e665cd4-da55-ae82-bdb7-c26e7ba91547@propaas.com> Date: Mon, 6 Nov 2017 12:34:39 -0700 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.3.0 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US 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 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. Thanks, Chris -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin