RE: Unable to archive logs in standby server

Hi Guillaume/team,

I set archive_mode = always in master and standby.

Archival to standby WAL directory completed when

• standby server was restarted
• pg_stop_backup was executed in master

But archival hangs when pg_stop_backup is executed in standby.

Could someone help to get this working?

postgres=# select pg_start_backup('test', true, false);

pg_start_backup

-----------------

1/F9000060

(1 row)

postgres=# select pg_stop_backup('f');

NOTICE:  base backup done, waiting for required WAL segments to be archived

WARNING:  still waiting for all required WAL segments to be archived (60 seconds elapsed)

HINT:  Check that your archive_command is executing properly.  You can safely cancel this backup, but the database backup will not be usable without all the WAL segments.

WARNING:  still waiting for all required WAL segments to be archived (120 seconds elapsed)

HINT:  Check that your archive_command is executing properly.  You can safely cancel this backup, but the database backup will not be usable without all the WAL segments.

……..

…………

postgres=# select pg_is_in_recovery();

pg_is_in_recovery

-------------------

t

(1 row)

postgres=# show wal_level;

wal_level

-----------

replica

(1 row)

postgres=# show archive_mode;

archive_mode

--------------

always

(1 row)

postgres=# select version();

                                                 version

---------------------------------------------------------------------------------------------------------

PostgreSQL 12.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit

(1 row)

Regards,

Meera