From: Joshua D. Drake <jd@commandprompt.com>
To: chris kim <chrisk@propaas.com>
To: pgsql-admin@postgresql.org
Subject: Re: Standby wal issue
Date: Mon, 6 Nov 2017 13:22:26 -0800
Message-ID: <4bc00717-c926-675f-b826-40f3324ce4fd@commandprompt.com> (raw)
In-Reply-To: <2e665cd4-da55-ae82-bdb7-c26e7ba91547@propaas.com>
References: <2e665cd4-da55-ae82-bdb7-c26e7ba91547@propaas.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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
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: jd@commandprompt.com, chrisk@propaas.com
Subject: Re: Standby wal issue
In-Reply-To: <4bc00717-c926-675f-b826-40f3324ce4fd@commandprompt.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