RE: Unable to archive logs in standby server

Hi Christophe,

If pg_stop_backup is executed in master OR if standby server is restarted, I can see the archiving completing fine.
Only issue is while manually executing the pg_stop_backup in standby

Regards,
Meera

-----Original Message-----
From: Christophe Pettus <xof(at)thebuild(dot)com>
Sent: Friday, September 2, 2022 7:43 PM
To: Meera Nair <mnair(at)commvault(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org; Punit Pranesh Koujalgi <pkoujalgi(at)commvault(dot)com>
Subject: Re: Unable to archive logs in standby server

External email. Inspect before opening.

> On Sep 1, 2022, at 21:41, Meera Nair <mnair(at)commvault(dot)com> wrote:
> Archival hangs. Is this expected?
> 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.

This generally means the command being run by archive_command is failing. Check the PostgreSQL logs (if you are using CSV logs, check the *.log file rather than the *.csv file).