About pg_basebackup

Started by 菊池祐almost 4 years ago2 messagesgeneral
Jump to latest
#1菊池祐
y.kikuchi0714@gmail.com

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

Attachments:

-6124946774920295119postgresql.confapplication/octet-stream; name=-6124946774920295119postgresql.conf; x-apple-part-url=8CAB9D85-6E40-4194-8368-C33B67130042Download
#2Laurenz Albe
laurenz.albe@cybertec.at
In reply to: 菊池祐 (#1)
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/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)

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

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