Re: About pg_basebackup - Mailing list pgsql-general

From Laurenz Albe
Subject Re: About pg_basebackup
Date
Msg-id 34e97beb7f8e2afbe463b42dced0d6b73364e568.camel@cybertec.at
Whole thread Raw
In response to About pg_basebackup  (菊池祐 <y.kikuchi0714@gmail.com>)
List pgsql-general
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



pgsql-general by date:

Previous
From: 菊池祐
Date:
Subject: About pg_basebackup
Next
From: Laurenz Albe
Date:
Subject: Re: In case of network issues, how long before archive_command does retries