- Notifications
You must be signed in to change notification settings - Fork86
Description
Hi Team,
My env, I set postgres archive_timeout='30min' as below:
postgres=# show archive_timeout ;
archive_timeout
30min
(1 row)
postgres=# show archive_command ;
archive_command
/usr/bin/pg_probackup-12 archive-push -B /pg_backup_cfs --instance pgsql --wal-file-name=%f
(1 row)
postgres=#
pg_probackup-12 archive_timeout is the default setting 5min.
[postgres@10-176-2-190.rds-app-test.dgdev01 pgsql]$ pg_probackup-12 show-config -B /pg_backup_cfs/ --instance pgsql
Backup instance information
pgdata = /home/service/var/postgresql/pgdata
system-identifier = 6935366216063820515
xlog-seg-size = 536870912
Connection parameters
pgdatabase = postgres
Replica parameters
replica-timeout = 5min
Archive parameters
archive-timeout = 5min
Logging parameters
log-level-console = INFO
log-level-file = OFF
log-filename = pg_probackup.log
log-rotation-size = 0TB
log-rotation-age = 0d
Retention parameters
retention-redundancy = 2
retention-window = 15
wal-depth = 0
Compression parameters
compress-algorithm = none
compress-level = 1
Remote access parameters
remote-proto = ssh
[postgres@10-176-2-190.rds-app-test.dgdev01 pgsql]$
but I always meet backup wait for archive problem, and lead to backup fail.
How to solve this to make backup task always complete success? thanks a lot!
[postgres@10-176-2-190.rds-app-test.dgdev01 pgsql]$ pg_probackup-12 backup -B $PG_BACKUP_DIR --instance $PG_CLUSTER_NAME -b full --compress-algorithm=zlib --compress-level=1
INFO: Backup start, pg_probackup version: 2.4.9, instance: pgsql, backup ID: QPE3W1, backup mode: FULL, wal mode: ARCHIVE, remote: false, compress-algorithm: zlib, compress-level: 1
WARNING: Current PostgreSQL role is superuser. It is not recommended to run backup or checkdb as superuser.
INFO: Backup QPE3W1 is going to be taken from standby
INFO: PGDATA size: 30MB
INFO: Start transferring data files
INFO: Data files are transferred, time elapsed: 3s
INFO: wait for pg_stop_backup()
INFO: pg_stop backup() successfully executed
INFO: Wait for LSN 1/20000060 in archived WAL segment /pg_backup_cfs/wal/pgsql/000000010000000100000001
ERROR: WAL segment 000000010000000100000001 could not be archived in 300 seconds
WARNING: Backup QPE3W1 is running, setting its status to ERROR
[postgres@10-176-2-190.rds-app-test.dgdev01 pgsql]$ pg_probackup-12 show -B $PG_BACKUP_DIR
BACKUP INSTANCE 'pgsql'
Instance Version ID Recovery Time Mode WAL Mode TLI Time Data WAL Zratio Start LSN Stop LSN Status
pgsql 12 QPE3W1 ---- FULL ARCHIVE 1/0 5m:5s 104kB 0 1.00 0/C00001D0 0/0 ERROR
pgsql 12 QPE3Q5 2021-03-03 18:59:17+08 FULL ARCHIVE 1/0 3m:17s 10010kB 1024MB 3.07 0/C00001D0 1/28 OK
[postgres@10-176-2-190.rds-app-test.dgdev01 pgsql]$