> On Sep 1, 2022, at 21:41, Meera Nair <mn...@commvault.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).