pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jeff Frost <jeff@pgexperts.com>
To: Jorge Torralba <jorge.torralba@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: standby not cleaning up WAL files often enough
Date: Wed, 22 Apr 2015 17:23:45 -0700
Message-ID: <F05A2C84-38CF-44E8-9AFC-FFB3E429E5E6@pgexperts.com> (raw)
In-Reply-To: <CACut7uQRSmW6FpJfjhKu3oC_S-HqxLRcu5BvP8TAK-2VKYsa3g@mail.gmail.com>
References: <EE4EF5D6-EF29-41F6-9A0C-C861D95E669A@pgexperts.com>
	<CACut7uTdbjrcnyRuhXuSCPWGow+J1XxZC0v4sFefek7oxY578w@mail.gmail.com>
	<CCD3CA07-A3E3-4105-92F1-F745E50EF4DB@pgexperts.com>
	<CACut7uQRSmW6FpJfjhKu3oC_S-HqxLRcu5BvP8TAK-2VKYsa3g@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

Like I mentioned before, it’s the *replica* not the primary. I.e. it’s not archiving. There are no cascaded replicas getting their WAL stream from it either.


postgres=# show wal_keep_segments ;
 wal_keep_segments
-------------------
 0
(1 row)



> On Apr 22, 2015, at 5:08 PM, Jorge Torralba <jorge.torralba@gmail.com> wrote:
> 
> More of statng the obvious here :)
> 
> Make sure your archive directory is mounted or accessible from the DB server.
> 
> Check your wal_keep_segments. I cant imagine them being 3000 but you never know.
> 
> are you running synchronous or asynchronous replication?
> 
> JT
> 
> On Wed, Apr 22, 2015 at 5:02 PM, Jeff Frost <jeff@pgexperts.com <mailto:jeff@pgexperts.com>> wrote:
> It’s a good question, but I’m actually not talking about the WAL files in the archive (those are on S3), I’m talking about the WAL files in the pg_xlog directory.
> 
> > On Apr 22, 2015, at 5:00 PM, Jorge Torralba <jorge.torralba@gmail.com <mailto:jorge.torralba@gmail.com>> wrote:
> >
> > Stupid question but it needs to be asked.
> >
> > Do you have this in your recovery.conf file ?
> >
> > archive_cleanup_command = 'pg_archivecleanup path to archived files %r’
> 
> 
> 
> 
> -- 
> Thanks,
> 
> Jorge Torralba
> ----------------------------
> 
> Note: This communication may contain privileged or other confidential information. If you are not the intended recipient, please do not print, copy, retransmit, disseminate or otherwise use the information. Please indicate to the sender that you have received this email in error and delete the copy you received. Thank You.

---
Jeff Frost <jeff@pgexperts.com>
CTO, PostgreSQL Experts, Inc.
Phone: 1-888-PG-EXPRT x506
FAX: 415-762-5122
http://www.pgexperts.com/ 

view thread (6+ messages)

Message-ID: <F05A2C84-38CF-44E8-9AFC-FFB3E429E5E6@pgexperts.com>
Permalink:  ../F05A2C84-38CF-44E8-9AFC-FFB3E429E5E6@pgexperts.com/
Also on:    postgresql.org/message-id/F05A2C84-38CF-44E8-9AFC-FFB3E429E5E6@pgexperts.com

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: jeff@pgexperts.com, jorge.torralba@gmail.com
  Subject: Re: standby not cleaning up WAL files often enough
  In-Reply-To: <F05A2C84-38CF-44E8-9AFC-FFB3E429E5E6@pgexperts.com>
  References: <EE4EF5D6-EF29-41F6-9A0C-C861D95E669A@pgexperts.com> <CACut7uTdbjrcnyRuhXuSCPWGow+J1XxZC0v4sFefek7oxY578w@mail.gmail.com> <CCD3CA07-A3E3-4105-92F1-F745E50EF4DB@pgexperts.com> <CACut7uQRSmW6FpJfjhKu3oC_S-HqxLRcu5BvP8TAK-2VKYsa3g@mail.gmail.com> <F05A2C84-38CF-44E8-9AFC-FFB3E429E5E6@pgexperts.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