MIME-Version: 1.0
References: 
 <CAEu96cXnBOEiDTC+uCRJwNWqaLT-+ApgA_VOehdfO-9Ntmsc9w@mail.gmail.com>
In-Reply-To: 
 <CAEu96cXnBOEiDTC+uCRJwNWqaLT-+ApgA_VOehdfO-9Ntmsc9w@mail.gmail.com>
From: masheed ullah <masheedullah@gmail.com>
Date: Wed, 1 Jul 2026 10:15:14 +0300
Message-ID: 
 <CAHr8x_s-EBi4Fk-1aM1xB0iFn9p35+inu6SNN=LVpAZyuo+W2w@mail.gmail.com>
Subject: Re: Postgresql Wal archive and Barman setup
To: sa sa <ssmaugust@gmail.com>
Cc: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000cdb1df065587746a"
Archived-At: 
 <https://www.postgresql.org/message-id/CAHr8x_s-EBi4Fk-1aM1xB0iFn9p35%2Binu6SNN%3DLVpAZyuo%2BW2w%40mail.gmail.com>
Precedence: bulk

--000000000000cdb1df065587746a
Content-Type: text/plain; charset="UTF-8"

You need to actively monitor archive location to avoid space issue.

Schedule a job to send alert email when archive location full to 80% or 90%

Best Regards,
*Masheed Ullah*


On Tue, Jun 30, 2026, 11:36 PM sa sa <ssmaugust@gmail.com> wrote:

> Hello All,
>
>  I have a scenario, where I need some suggestions and improvements if
> applicable.
>
> Our setup in brief
> 1) Primary --> standby
>     using archive_command = rsync to primary local location and standby
> local location
> 2) Primary --> Barman
>     Using streaming. Barman backup location is /nfs/DD9
> 3) Archive cleanup on primary is setup via crontab to every 14 days.
>
> Here is my scenario, If my barman nfs is down for 5 days and my local
> archive location is filled up during this time. what will happen.
>
> if my /srv/archive (location archive wal location) on primary and standby
> is 100% full during this time.
> my /srv/data is going to be 100% full , causing my cluster to go down.
>
> So what are the suggestions to avoid this situation.
>
> Thanks,
> Sa
>

--000000000000cdb1df065587746a
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><div dir=3D"auto"><div><div>You need to actively monitor =
archive location to avoid space issue.</div><div dir=3D"auto"><br></div><di=
v dir=3D"auto">Schedule a job to send alert email when archive location ful=
l to 80% or 90%</div><div><br></div><div data-smartmail=3D"gmail_signature"=
><div dir=3D"ltr"><div><font face=3D"sans-serif" size=3D"2">Best Regards,</=
font><font size=3D"3"> </font><font face=3D"sans-serif" size=3D"2"><br>
<b>Masheed <font size=3D"2">Ullah</font></b> <br>
</font><br></div><br></div></div><br><div class=3D"gmail_quote gmail_quote_=
container"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, Jun 30, 2026, 11:3=
6 PM sa sa &lt;<a href=3D"mailto:ssmaugust@gmail.com">ssmaugust@gmail.com</=
a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0 =
0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr">Hell=
o All,<div><br></div><div>=C2=A0I have a scenario, where I need some sugges=
tions and improvements if applicable.</div><div><br></div><div>Our setup in=
 brief</div><div>1) Primary --&gt; standby</div><div>=C2=A0 =C2=A0 using ar=
chive_command =3D rsync to primary local location and standby local locatio=
n</div><div>2) Primary --&gt; Barman</div><div>=C2=A0 =C2=A0 Using streamin=
g. Barman backup location is /nfs/DD9</div><div>3) Archive cleanup on prima=
ry is setup via crontab to every 14 days.</div><div><br></div><div><span st=
yle=3D"color:rgb(0,0,0);font-size:medium">Here is my scenario, If my barman=
 nfs is down for 5 days and my local archive location is filled up during t=
his time. what will happen.</span><br></div><div><span style=3D"color:rgb(0=
,0,0);font-size:medium"><br></span></div><div><font color=3D"#000000" size=
=3D"3">if my /srv/archive (location archive wal location) on primary and st=
andby is 100% full during this time.=C2=A0</font></div><div><font color=3D"=
#000000" size=3D"3">my /srv/data is going to be 100% full , causing my clus=
ter to go down.</font></div><div><font color=3D"#000000" size=3D"3"><br></f=
ont></div><div><font color=3D"#000000" size=3D"3">So what are the suggestio=
ns to avoid this situation.</font></div><div><font color=3D"#000000" size=
=3D"3"><br></font></div><div><font color=3D"#000000" size=3D"3">Thanks,</fo=
nt></div><div><font color=3D"#000000" size=3D"3">Sa</font></div></div>
</blockquote></div></div></div><br><br></div>

--000000000000cdb1df065587746a--