Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Yl4vo-0000my-FG for pgsql-admin@arkaria.postgresql.org; Thu, 23 Apr 2015 00:23:52 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Yl4vn-00043Y-Lr for pgsql-admin@arkaria.postgresql.org; Thu, 23 Apr 2015 00:23:51 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Yl4vm-00043P-DL for pgsql-admin@postgresql.org; Thu, 23 Apr 2015 00:23:50 +0000 Received: from smtp106.ord1c.emailsrvr.com ([108.166.43.106]) by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1Yl4vj-0006Bg-Lj for pgsql-admin@postgresql.org; Thu, 23 Apr 2015 00:23:48 +0000 Received: from smtp14.relay.ord1c.emailsrvr.com (localhost.localdomain [127.0.0.1]) by smtp14.relay.ord1c.emailsrvr.com (SMTP Server) with ESMTP id EAE28380893; Wed, 22 Apr 2015 20:23:46 -0400 (EDT) Received: by smtp14.relay.ord1c.emailsrvr.com (Authenticated sender: jeff.frost-AT-pgexperts.com) with ESMTPSA id 7D9513809CE; Wed, 22 Apr 2015 20:23:46 -0400 (EDT) X-Sender-Id: jeff.frost@pgexperts.com Received: from [10.10.10.9] (8.202-62-69.ftth.swbr.surewest.net [69.62.202.8]) (using TLSv1 with cipher DHE-RSA-AES256-SHA) by 0.0.0.0:587 (trex/5.4.2); Thu, 23 Apr 2015 00:23:46 GMT Content-Type: multipart/alternative; boundary="Apple-Mail=_B8D2814E-EECC-42AD-B289-81AB55F7D5D3" Mime-Version: 1.0 (Mac OS X Mail 8.2 \(2070.6\)) Subject: Re: standby not cleaning up WAL files often enough From: Jeff Frost In-Reply-To: Date: Wed, 22 Apr 2015 17:23:45 -0700 Cc: "pgsql-admin@postgresql.org" Message-Id: References: To: Jorge Torralba X-Mailer: Apple Mail (2.2070.6) X-Pg-Spam-Score: -1.9 (-) 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 --Apple-Mail=_B8D2814E-EECC-42AD-B289-81AB55F7D5D3 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Like I mentioned before, it=E2=80=99s the *replica* not the primary. = I.e. it=E2=80=99s not archiving. There are no cascaded replicas getting = their WAL stream from it either. postgres=3D# show wal_keep_segments ; wal_keep_segments ------------------- 0 (1 row) > On Apr 22, 2015, at 5:08 PM, Jorge Torralba = wrote: >=20 > More of statng the obvious here :) >=20 > Make sure your archive directory is mounted or accessible from the DB = server. >=20 > Check your wal_keep_segments. I cant imagine them being 3000 but you = never know. >=20 > are you running synchronous or asynchronous replication? >=20 > JT >=20 > On Wed, Apr 22, 2015 at 5:02 PM, Jeff Frost > wrote: > It=E2=80=99s a good question, but I=E2=80=99m actually not talking = about the WAL files in the archive (those are on S3), I=E2=80=99m = talking about the WAL files in the pg_xlog directory. >=20 > > On Apr 22, 2015, at 5:00 PM, Jorge Torralba = > wrote: > > > > Stupid question but it needs to be asked. > > > > Do you have this in your recovery.conf file ? > > > > archive_cleanup_command =3D 'pg_archivecleanup path to archived = files %r=E2=80=99 >=20 >=20 >=20 >=20 > --=20 > Thanks, >=20 > Jorge Torralba > ---------------------------- >=20 > 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 CTO, PostgreSQL Experts, Inc. Phone: 1-888-PG-EXPRT x506 FAX: 415-762-5122 http://www.pgexperts.com/=20 --Apple-Mail=_B8D2814E-EECC-42AD-B289-81AB55F7D5D3 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8
Like I mentioned before, it=E2=80=99s the = *replica* not the primary. I.e. it=E2=80=99s not archiving. There are no = cascaded replicas getting their WAL stream from it either.


postgres=3D# 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> wrote:
It=E2=80=99s a good = question, but I=E2=80=99m actually not talking about the WAL files in = the archive (those are on S3), I=E2=80=99m talking about the WAL files = in the pg_xlog directory.

> On Apr 22, 2015, at 5:00 PM, Jorge Torralba <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 =3D 'pg_archivecleanup path to = archived files %r=E2=80=99




--
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



= --Apple-Mail=_B8D2814E-EECC-42AD-B289-81AB55F7D5D3--