MIME-Version: 1.0
References: <CAKgGyB9pD2JtjN2RwZ5_jUnQN7OvQrJZ_oOMffXQFhcx02n0aA@mail.gmail.com>
 <CAKAnmmKHuJGL5g+yWchJqDFA67Cveo3O+PkqDNDwnkN++QJPGA@mail.gmail.com>
In-Reply-To: <CAKAnmmKHuJGL5g+yWchJqDFA67Cveo3O+PkqDNDwnkN++QJPGA@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Thu, 29 Aug 2024 10:47:23 -0400
Message-ID: <CANzqJaCR28GEWA_NsfBwzpFJpjakKcX5HsPT9=N+VPpsdRGamA@mail.gmail.com>
Subject: Re: PgBackRest client_loop: send disconnect: Connection reset
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000003458f30620d38eb5"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaCR28GEWA_NsfBwzpFJpjakKcX5HsPT9%3DN%2BVPpsdRGamA%40mail.gmail.com>
Precedence: bulk

--0000000000003458f30620d38eb5
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Thu, Aug 29, 2024 at 10:12=E2=80=AFAM Greg Sabino Mullane <htamfids@gmai=
l.com>
wrote:

> On Thu, Aug 29, 2024 at 9:31=E2=80=AFAM KK CHN <kkchn.in@gmail.com> wrote=
:
>
>> "Unable to acquire lock on file '/tmp/pgbackrest/Repo-backup.lock'
>>
>
> When this happens, take a look inside this file. If there is another
> pgbackrest process running, the pid will be inside that file. Kill that
> process before trying to run another backup.
>

Or don't run pgbackrest when another instance is running.  This is what I
do:
pgrep -a pgbackrest | grep -q "pgbackrest backup" && { echo "another
pgbackrest back is running"; exit 1; }

(There's probably a better way to check that, but this works.)

--=20
Death to America, and butter sauce.
Iraq lobster!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Thu, Aug 29, 2024 at 10:12=E2=80=AFAM =
Greg Sabino Mullane &lt;<a href=3D"mailto:htamfids@gmail.com">htamfids@gmai=
l.com</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">On Thu, =
Aug 29, 2024 at 9:31=E2=80=AFAM KK CHN &lt;<a href=3D"mailto:kkchn.in@gmail=
.com" target=3D"_blank">kkchn.in@gmail.com</a>&gt; wrote:<br></div><div cla=
ss=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0p=
x 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div d=
ir=3D"ltr"><div>&quot;Unable to acquire lock on file &#39;/tmp/pgbackrest/R=
epo-backup.lock&#39;</div></div></blockquote><div><br></div><div>When this =
happens, take a look inside this file. If there is another pgbackrest proce=
ss running, the pid will be inside that file. Kill that process before tryi=
ng to run another backup.</div><div></div></div></div></blockquote></div><d=
iv><br></div>Or don&#39;t run pgbackrest when another instance is running.=
=C2=A0 This is what I do:<div>pgrep -a pgbackrest | grep -q &quot;pgbackres=
t backup&quot; &amp;&amp; { echo &quot;another pgbackrest back is running&q=
uot;; exit 1; }<br></div><div><div><br></div><div>(There&#39;s probably a b=
etter way to check that, but this works.)</div><div><br></div><span class=
=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_s=
ignature"><div dir=3D"ltr">Death to America, and butter sauce.<div>Iraq lob=
ster!</div></div></div></div></div>

--0000000000003458f30620d38eb5--