From: =?utf-8?Q?Niels_Kristian_Schj=C3=B8dt?= <nielskristian@autouncle.com>
Content-Type: multipart/alternative;
 boundary="Apple-Mail=_CED95182-6C05-46B5-9366-FA2688DEF79B"
Subject: pg_xlog dir not getting swept
Message-Id: <21D0DA77-ACC3-4859-A391-03EE0B5D7E76@autouncle.com>
Date: Wed, 29 Jun 2016 12:00:00 +0200
To: "pgsql-performance@postgresql.org list" <pgsql-performance@postgresql.org>
Mime-Version: 1.0 (Mac OS X Mail 9.3 \(3124\))
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org


--Apple-Mail=_CED95182-6C05-46B5-9366-FA2688DEF79B
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8

About a day ago, there seems to have been some trouble in the network of =
my database (postgresql 9.3).=20

I=E2=80=99m running my db with a streaming replication setup with wall =
shipping.=20

I sync wal logs to a mounted networkdrive using archive_command =3D =
'rsync -a %p /mnt/wal_drive/wals/%f </dev/null=E2=80=99. Somehow this =
command was failing, leading to my pg_xlog dir building up (590Gb). I =
rebooted the server, and the archiving command seems to succeed now - =
however - After about an hour of running, the pg_xlog drive has not =
decreased in size - I would have expect that! I can see that lot=E2=80=99s=
 of files get=E2=80=99s synced to the /mnt/wal_drive/wals dir, but =
somehow the pg_xlog dir is not swept (yet)? Will this happen =
automatically eventually, or do I need to do something manually?

PS. I found this blog post http://www.hivelogik.com/blog/?p=3D513, but =
I=E2=80=99m unsure if it=E2=80=99s necessary and if it can be dangerous?

Best=

--Apple-Mail=_CED95182-6C05-46B5-9366-FA2688DEF79B
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=utf-8

<html><head><meta http-equiv=3D"Content-Type" content=3D"text/html =
charset=3Dutf-8"></head><body style=3D"word-wrap: break-word; =
-webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" =
class=3D"">About a day ago, there seems to have been some trouble in the =
network of my database (postgresql 9.3).&nbsp;<div class=3D""><br =
class=3D""></div><div class=3D"">I=E2=80=99m running my db with a =
streaming replication setup with wall shipping.&nbsp;<div class=3D""><br =
class=3D""></div><div class=3D"">I sync wal logs to a mounted =
networkdrive using&nbsp;<font face=3D"Helvetica Neue" size=3D"2" =
class=3D"">archive_command =3D 'rsync -a %p /mnt/wal_drive/wals/%f =
&lt;/dev/null=E2=80=99. Somehow this command was failing, leading to my =
pg_xlog dir building up (590Gb). I rebooted the server, and the =
archiving command seems to succeed now - however - After about an hour =
of running, the pg_xlog drive has not decreased in size - I would have =
expect that! I can see that lot=E2=80=99s of files get=E2=80=99s synced =
to the /mnt/wal_drive/wals dir, but somehow the pg_xlog dir is not swept =
(yet)? Will this happen automatically eventually, or do I need to do =
something manually?</font><div class=3D""><font face=3D"Helvetica Neue" =
size=3D"2" class=3D""><br class=3D""></font></div><div class=3D""><font =
face=3D"Helvetica Neue" size=3D"2" class=3D"">PS. I found this blog =
post&nbsp;<a href=3D"http://www.hivelogik.com/blog/?p=3D513" =
class=3D"">http://www.hivelogik.com/blog/?p=3D513</a></font><span =
style=3D"font-family: 'Helvetica Neue'; font-size: small;" class=3D"">, =
but I=E2=80=99m unsure if it=E2=80=99s&nbsp;necessary&nbsp;and if it can =
be&nbsp;dangerous?</span></div><div class=3D""><div class=3D""><span =
style=3D"color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; =
font-style: normal; font-variant: normal; font-weight: normal; =
letter-spacing: normal; line-height: normal; orphans: auto; text-align: =
start; text-indent: 0px; text-transform: none; white-space: normal; =
widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;"><br =
class=3D"Apple-interchange-newline">
</span></div>
Best</div></div></div></body></html>=

--Apple-Mail=_CED95182-6C05-46B5-9366-FA2688DEF79B--