Search Postgresql Archives

Re: Unable to archive logs in standby server

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

Le jeu. 21 juil. 2022 à 13:58, Meera Nair <mnair@xxxxxxxxxxxxx> 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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux