MIME-Version: 1.0
References: <CAGbX52Fg2jxqGVZzeQ_QcHSZ8fgDjnVZUJy5NUb5-PAf8fvxkw@mail.gmail.com>
 <52afa4c9-7393-4265-88bb-6393f1b0fb03@aklaver.com>
In-Reply-To: <52afa4c9-7393-4265-88bb-6393f1b0fb03@aklaver.com>
From: Koen De Groote <kdg.dev@gmail.com>
Date: Sun, 29 Sep 2024 17:57:39 +0200
Message-ID: <CAGbX52EyjjOQJUjA0m4+0azs_yH1by63p6hhJg7Y66=VCCqzpA@mail.gmail.com>
Subject: Re: Basebackup fails without useful error message
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: PostgreSQL General <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000008ddf8e0623442695"
Archived-At: <https://www.postgresql.org/message-id/CAGbX52EyjjOQJUjA0m4%2B0azs_yH1by63p6hhJg7Y66%3DVCCqzpA%40mail.gmail.com>
Precedence: bulk

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

> What is the complete command you are using?

The full command is:

pg_basebackup -h localhost -p 5432 -U basebackup_user -D
/mnt/base_backup/dir -Ft -z -P

So output Format as tar, gzipped, and with progress being printed.

> Have you looked at the Postgres log?

> Is --verbose being used?

This is straight from the logs, it's the only output besides the % progress
counter.

Will have a look at --verbose.

Regards,
Koen De Groote

On Sun, Sep 29, 2024 at 5:01=E2=80=AFPM Adrian Klaver <adrian.klaver@aklave=
r.com>
wrote:

> On 9/29/24 07:48, Koen De Groote wrote:
> > Having run a basebackup, I'm getting this output at the very end:
> >
> > pg_basebackup: child process exited with error 1
> > pg_basebackup: removing contents of data directory
> "/mnt/base_backup/dir/"
>
> What is the complete command you are using?
>
> >
> > Is there a way to get more information as to what exactly happened?
>
> Have you looked at the Postgres log?
>
> Is --verbose being used?
>
> >
> > I'd like to look into fixing this or doing whatever is required so that
> > it doesn't happen again, but this just isn't enough info. Where do I
> > start looking?
> >
> > Regards,
> > Koen De Groote
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>
>

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

<div dir=3D"ltr"><div>&gt;
What is the complete command you are using?</div><div><br></div><div>The fu=
ll command is:</div><div><br></div><div>pg_basebackup -h localhost -p 5432 =
-U basebackup_user -D /mnt/base_backup/dir -Ft -z -P</div><div><br></div><d=
iv>So output Format as tar, gzipped, and with progress being printed.<br></=
div><div><br></div><div>&gt;
Have you looked at the Postgres log?<br>
<br>&gt; Is --verbose being used?

</div><div><br></div><div>This is straight from the logs, it&#39;s the only=
 output besides the % progress counter.</div><div><br></div><div>Will have =
a look at --verbose.</div><div><br></div><div>Regards,</div><div>Koen De Gr=
oote<br></div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=
=3D"gmail_attr">On Sun, Sep 29, 2024 at 5:01=E2=80=AFPM Adrian Klaver &lt;<=
a href=3D"mailto:adrian.klaver@aklaver.com">adrian.klaver@aklaver.com</a>&g=
t; wrote:<br></div><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">On 9/2=
9/24 07:48, Koen De Groote wrote:<br>
&gt; Having run a basebackup, I&#39;m getting this output at the very end:<=
br>
&gt; <br>
&gt; pg_basebackup: child process exited with error 1<br>
&gt; pg_basebackup: removing contents of data directory &quot;/mnt/base_bac=
kup/dir/&quot;<br>
<br>
What is the complete command you are using?<br>
<br>
&gt; <br>
&gt; Is there a way to get more information as to what exactly happened?<br=
>
<br>
Have you looked at the Postgres log?<br>
<br>
Is --verbose being used?<br>
<br>
&gt; <br>
&gt; I&#39;d like to look into fixing this or doing whatever is required so=
 that <br>
&gt; it doesn&#39;t happen again, but this just isn&#39;t enough info. Wher=
e do I <br>
&gt; start looking?<br>
&gt; <br>
&gt; Regards,<br>
&gt; Koen De Groote<br>
<br>
-- <br>
Adrian Klaver<br>
<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank">adrian.klave=
r@aklaver.com</a><br>
<br>
</blockquote></div>

--0000000000008ddf8e0623442695--