|
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) postgres=# show archive_command; archive_command ------------------------------------------------ copy "%p" "D:\PostgreSQL\14\standby_14\wal\%f" (1 row) Regards, Meera |
