Re: Unable to archive logs in standby server - Mailing list pgsql-general

From Christophe Pettus
Subject Re: Unable to archive logs in standby server
Date
Msg-id 28429F2F-A1BA-42D8-9DC7-FCA27390AD0C@thebuild.com
Whole thread Raw
In response to RE: Unable to archive logs in standby server  (Meera Nair <mnair@commvault.com>)
Responses RE: Unable to archive logs in standby server
List pgsql-general

> On Sep 1, 2022, at 21:41, Meera Nair <mnair@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
backupwill 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
backupwill 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
CSVlogs, check the *.log file rather than the *.csv file). 


pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: How to make PostreSQL utilities honor home directories?
Next
From: Jeffrey Walton
Date:
Subject: Re: How to make PostreSQL utilities honor home directories?