Re: Unable to archive logs in standby server

Hi,

Le jeu. 21 juil. 2022 à 13:58, Meera Nair <mnair(at)commvault(dot)com> a écrit :

> Hi team,
>
>
>
> With non-exclusive backup method, trying backup from standby node.
>
> But pg_stop_backup function returns “WAL archiving is not enabled…” and
> the logs are not archived to WAL directory configured.
>
>
>
> Please check if I am missing anything in configuring this properly,
>
> Server was restarted after setting the archiving params in postgresql.conf
>
>
>
> Below is from version 14:
>
>
>
> postgres=# select pg_start_backup('label', false, false);
>
> pg_start_backup
>
> -----------------
>
> 0/60000D8
>
> (1 row)
>
>
>
>
>
> postgres=# select pg_stop_backup('false');
>
> NOTICE: WAL archiving is not enabled; you must ensure that all required
> WAL segments are copied through other means to complete the backup
>
> pg_stop_backup
>
> ---------------------------------------------------------------------------
>
> (0/60001C0,"START WAL LOCATION: 0/60000D8 (file 000000010000000000000006)+
>
> CHECKPOINT LOCATION: 0/6000110 +
>
> BACKUP METHOD: streamed +
>
> BACKUP FROM: standby +
>
> START TIME: 2022-07-21 12:42:11 IST +
>
> LABEL: label +
>
> START TIMELINE: 1 +
>
> ","")
>
> (1 row)
>
>
>
>
>
> 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
>
> --------------
>
> on
>
> (1 row)
>
>
>

You're doing backups from the standby, and to allow archiving on the
backups, archive_mode should be set to always.

--
Guillaume.