Re: About pg_basebackup

On Thu, 2022-05-19 at 13:18 +0900, 菊池祐 wrote:
> 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/12609150596kB (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
backupwill 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)

I guess that your "archive_command" is hanging or failing.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com