Postgres Pro
Downloads
Home   >   mailing lists

pg_xlog on slaves has grown to 200GB - Mailing list pgsql-general

From Vikas Sharma
Subject pg_xlog on slaves has grown to 200GB
Date
Msg-id CAN6gwKydz6mid68EKVgU7WMJcRG4mv=RACeJmyJVA=AKoyV3nw@mail.gmail.com
Whole thread Raw
Responses Re: pg_xlog on slaves has grown to 200GB
Re: pg_xlog on slaves has grown to 200GB
List pgsql-general
Tree view
Hello,

We are using postgresql 9.5 with repmgr 3.3.2 in streaming replication setup with 1 master and 2 slaves. I have noticed that the pg_xlog on slaves has grown to 200GB and is still growing. 

Please advise why pg_xlog is growing and not pruning itself, is there any parameter I need to setup to accomplish this? or repmgr will control it itself. 

I am not 100% sure but feel it pg_xlog never used to grow this much or was clearing itself, I can see there are WALs since May 2019 but not before that. I want to understand why the WALs started accumulating since then. we have this setup since more than a year.

Best Regards
Vikas Sharma


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump problems: [archiver (db)] query failed: ERROR: relation "pg_opfamily" does not exist
Next
From: Stephen Frost
Date:
Subject: Re: postmaster utilization