[prev in list] [next in list] [prev in thread] [next in thread]
List: pgsql-bugs
Subject: Re: About pg_basebackup
From: <y.kikuchi0714 () gmail ! com>
Date: 2022-05-19 4:14:10
Message-ID: 87A19691-F8EE-4595-A974-DDC4FAFF88E8 () gmail ! com
[Download RAW message or body]
Thank you for quick response.
I'll ask pgsql-general mailing list.
Best regards,
Yu
> On May 19, 2022, at 12:46, David G. Johnston <david.g.johnston@gmail.com> wrote:
>
>
> > On Wed, May 18, 2022 at 8:35 PM 菊 祐 <y.kikuchi0714@gmail.com> wrote:
> > Hi,
> >
> > I executed the pg_basebackup command to set up a replication configuration in \
> > postgresql, but the following message appears and replication didn't complete.
> > 2741/2742 tablespaces (/var/lib/pgsql/9.2/bac12609150596/12609150596 kB (100%), \
> > 2741/2742 tablespaces (/var/lib/pgsql/9.2/bac12609150596/12609150596 kB (100%), \
> > 2742/2742 tablespaces NOTICE: pg_stop_backup cleanup done, waiting for required \
> > WAL segments to be archived WARNING: pg_stop_backup still waiting for all \
> > required WAL segments to be archived (60 seconds elapsed) HINT: Check that your \
> > archive_command is executing properly. pg_stop_backup can be canceled safely, but \
> > the database backup will not be usable without all the WAL segments. WARNING: \
> > pg_stop_backup still waiting for all required WAL segments to be archived (120 \
> > seconds elapsed) ・ ・ ・
> > Please let me know how to deal with this.
> >
>
> Impossible to say with the information provided. The PostgreSQL log file during \
> this period should prove informative. You have an archive_command set so look for \
> any messages indicating it is failing (just like the HINT says...)
> What specific version of the long unsupported version 9.2.x are you running?
>
> This seems unlikely to be a bug. Support questions are more appropriately directed \
> to the pgsql-general mailing list.
> David J.
>
[Attachment #3 (text/html)]
<html><head><meta http-equiv="content-type" content="text/html; \
charset=utf-8"></head><body dir="auto">Thank you for quick response.<div>I'll \
ask <span style="font-family: arial, helvetica, sans-serif;">pgsql-general \
mailing list.</span></div><div><font face="arial, helvetica, \
sans-serif"><br></font></div><div><font face="arial, helvetica, sans-serif">Best \
regards,</font></div><div><font face="arial, helvetica, sans-serif">Yu<br></font><div \
dir="ltr"><br><blockquote type="cite">On May 19, 2022, at 12:46, David G. Johnston \
<david.g.johnston@gmail.com> wrote:<br><br></blockquote></div><blockquote \
type="cite"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div \
class="gmail_default" style="font-family:arial,helvetica,sans-serif"><span \
style="font-family:Arial,Helvetica,sans-serif">On Wed, May 18, 2022 at 8:35 PM 菊 \
祐 <<a href="mailto:y.kikuchi0714@gmail.com">y.kikuchi0714@gmail.com</a>> \
wrote:</span><br></div></div><div class="gmail_quote"><blockquote class="gmail_quote" \
style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div dir="auto"><div dir="ltr"><p>Hi,</p><p>I \
executed the pg_basebackup command to set up a replication configuration in \
postgresql, but the following message appears and replication didn't \
complete.</p><p>2741/2742 tablespaces (/var/lib/pgsql/9.2/bac12609150596/12609150596 \
kB (100%), 2741/2742 tablespaces (/var/lib/pgsql/9.2/bac12609150596/12609150596 kB \
(100%), 2742/2742 tablespaces NOTICE: pg_stop_backup cleanup done, waiting for \
required WAL segments to be archived WARNING: pg_stop_backup still waiting for all \
required WAL segments to be archived (60 seconds elapsed) HINT: Check that your \
archive_command is executing properly. pg_stop_backup can be canceled safely, but the \
database backup will not be usable without all the WAL segments. WARNING: \
pg_stop_backup still waiting for all required WAL segments to be archived (120 \
seconds elapsed) ・ ・ ・</p><p>Please let me know how to deal with \
this.</p></div></div></blockquote><div><br></div><div class="gmail_default" \
style="font-family:arial,helvetica,sans-serif">Impossible to say with the information \
provided. The PostgreSQL log file during this period should prove \
informative. You have an archive_command set so look for any messages \
indicating it is failing (just like the HINT says...)</div><div class="gmail_default" \
style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" \
style="font-family:arial,helvetica,sans-serif">What specific version of the long \
unsupported version 9.2.x are you running?</div><div class="gmail_default" \
style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" \
style="font-family:arial,helvetica,sans-serif">This seems unlikely to be a bug. \
Support questions are more appropriately directed to the pgsql-general mailing \
list.</div><div class="gmail_default" \
style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" \
style="font-family:arial,helvetica,sans-serif">David J.</div><div \
class="gmail_default" \
style="font-family:arial,helvetica,sans-serif"><br></div></div></div> \
</div></blockquote></div></body></html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic