Postgres Pro
Downloads
Home   >   mailing lists

Thread: About pg_basebackup

About pg_basebackup

From
菊池祐
Date:

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. The environment is as follows and I attached postgresql.conf file.

Version : 9.2

OS : Cent 6.6


Attachment

Re: About pg_basebackup

From
Laurenz Albe
Date:
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