Skip to content

postgresql 13.5, wal_level=logical,PostgreSQL uses replication slots to synchronize data in real time, but pg_rman fails to backup #297

@wpxap

Description

@wpxap

[root@localhost ~]# su - postgres
Last login: Fri Aug 29 11:09:33 CST 2025 on pts/2
[postgres@localhost ~]$ pg_rman -b full -B /db/pg_rman -D /usr/local/pgsql/data -A /usr/local/pgsql/data/arch --keep-arclog-files=100 --debug -P backup
DEBUG: the initially configured target database : SYSTEM_IDENTIFIER = 7481918503983795082
DEBUG: the system identifier of current target database : 7481918503983795082
DEBUG: the backup target database is the same as initial configured one.
DEBUG: destination directories of backup are initialized
DEBUG: checking PostgreSQL server version
DEBUG: server version is 13.0.5
DEBUG: checking block size setting
DEBUG: (query) SELECT current_setting($1)
DEBUG: (param:0) = block_size
DEBUG: block size is 8192
DEBUG: checking block size setting
DEBUG: (query) SELECT current_setting($1)
DEBUG: (param:0) = wal_block_size
DEBUG: wal block size is 8192
DEBUG: data checksum disabled on the initially configured database
INFO: copying database files
DEBUG: executing pg_start_backup()
DEBUG: (query) SELECT * from pg_walfile_name_offset(pg_start_backup($1, $2, $3))
DEBUG: (param:0) = 2025-08-29 11:54:08 with pg_rman
DEBUG: (param:1) = true
DEBUG: (param:2) = false
DEBUG: backup start point is (WAL file: 0000000100000067000000A5, xrecoff: 40)
DEBUG: taking full backup of database files
Processed 15932 of 15932 files, skipped 0
DEBUG: executing pg_stop_backup()
DEBUG: (query) SET client_min_messages = warning;
DEBUG: (query) SELECT * FROM pg_stop_backup($1)
DEBUG: (param:0) = false
DEBUG: (query) SELECT * FROM pg_walfile_name_offset($1)
DEBUG: (param:0) = 67/A5752320
DEBUG: backup end point is (WAL file: 0000000100000067000000A5, xrecoff: 7676704)
DEBUG: waiting for 0000000100000067000000A5 is archived
DEBUG: (query) SELECT txid_current();
DEBUG: current XID is 19698666
DEBUG: WAL file containing backup end point is archived after waiting for 0 seconds
INFO: copying archived WAL files
DEBUG: turn to take a full backup of archived WAL files
DEBUG: taking backup of archived WAL files
ERROR: could not open destination file "/db/pg_rman/20250829/115408/arclog/20250829/000000010000006700000039": 没有那个文件或目录
DEBUG: update backup status from RUNNING to ERROR
[postgres@localhost ~]$

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions