Re: About pg_basebackup

On Wed, May 18, 2022 at 8:35 PM 菊池祐 <y(dot)kikuchi0714(at)gmail(dot)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.