pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedStandby wal issue
4+ messages / 3 participants
[nested] [flat]
* Standby wal issue
@ 2017-11-06 19:34 chris kim <chrisk@propaas.com>
2017-11-06 21:22 ` Re: Standby wal issue Joshua D. Drake <jd@commandprompt.com>
2017-11-07 07:30 ` Re: Standby wal issue Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 2 replies; 4+ messages in thread
From: chris kim @ 2017-11-06 19:34 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Standby wal issue
2017-11-06 19:34 Standby wal issue chris kim <chrisk@propaas.com>
@ 2017-11-06 21:22 ` Joshua D. Drake <jd@commandprompt.com>
2017-11-06 22:39 ` Re: Standby wal issue chris kim <chrisk@propaas.com>
1 sibling, 1 reply; 4+ messages in thread
From: Joshua D. Drake @ 2017-11-06 21:22 UTC (permalink / raw)
To: chris kim <chrisk@propaas.com>; pgsql-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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Standby wal issue
2017-11-06 19:34 Standby wal issue chris kim <chrisk@propaas.com>
2017-11-06 21:22 ` Re: Standby wal issue Joshua D. Drake <jd@commandprompt.com>
@ 2017-11-06 22:39 ` chris kim <chrisk@propaas.com>
0 siblings, 0 replies; 4+ messages in thread
From: chris kim @ 2017-11-06 22:39 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; pgsql-admin
Thanks for helping. Here's the recovery.conf file:
standby_mode= 'on'
trigger_file = '/tmp/standby.trg'
archive_cleanup_command = '/usr/pgsql-9.2/bin/pg_archivecleanup
/ComplianceDB/data/pg_xlog/ %r'
On 11/06/2017 02:22 PM, Joshua D. Drake wrote:
> 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
>>
>>
>>
>
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Standby wal issue
2017-11-06 19:34 Standby wal issue chris kim <chrisk@propaas.com>
@ 2017-11-07 07:30 ` Laurenz Albe <laurenz.albe@cybertec.at>
1 sibling, 0 replies; 4+ messages in thread
From: Laurenz Albe @ 2017-11-07 07:30 UTC (permalink / raw)
To: chris kim <chrisk@propaas.com>; pgsql-admin
chris kim wrote:
> 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.
Check the "pg_stat_replication" view to see if the standby keeps up
applying the changes - failure to do so could be a reason for WAL piling up.
If host standby is active, is "max_standby_streaming_delay" configured so that
long running transactions on the standby could block replication?
Yours,
Laurenz Albe
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2017-11-07 07:30 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-11-06 19:34 Standby wal issue chris kim <chrisk@propaas.com>
2017-11-06 21:22 ` Joshua D. Drake <jd@commandprompt.com>
2017-11-06 22:39 ` chris kim <chrisk@propaas.com>
2017-11-07 07:30 ` Laurenz Albe <laurenz.albe@cybertec.at>
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