Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

backup fail caused by wait for archive log #340

Open
Labels
@louteq

Description

@louteq

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]$

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions


      [8]ページ先頭

      ©2009-2025 Movatter.jp