使用EDB Bart实用程序和存档命令

Question

我对Postgres 10.13中的EDB、bart.cfg和archive_command有一个奇怪的问题。实际上，存档日志在/u 01/app/Postgres/ ARCHIVE_PATH /生成，但不知道为什么ARCHIVE_PATH会出现在bart显示服务器中。正因为如此，我的增量备份失败了。

bart.cfg

[BART]
bart_host= postgres@localhost
backup_path = /u01/app/Postgres/backups
pg_basebackup_path = /u01/app/EDB_Postgres10/bin/pg_basebackup

[prod2.naveed.com]
host = prod2.naveed.com
port = 5432
user = postgres
cluster_owner = postgres
pg_basebackup_path = /u01/app/EDB_Postgres10/bin/pg_basebackup
tablespace_path = 16393=/u01/app/Postgres/tablespaces
archive_command='cp %p /u01/app/Postgres/archivelogs/%f'
allow_incremental_backups = enabled

bart展示服务器-s prod2.naveed.com

SERVER NAME         : prod2.naveed.com
HOST NAME           : prod2.naveed.com
USER NAME           : postgres
PORT                : 5432
REMOTE HOST         :
RETENTION POLICY    : none
DISK UTILIZATION    : 47.21 MB
WARNING: not marking any WALs as unused WALs, the WAL file '/u01/app/Postgres/backups/prod2.naveed.com/archived_wals/000000010000000000000008' is required, yet not available in archived_wals directory
NUMBER OF ARCHIVES  : 0
ARCHIVE PATH        : /u01/app/Postgres/backups/prod2.naveed.com/archived_wals
ARCHIVE COMMAND     : cp %p /u01/app/Postgres/archivelogs/%f
XLOG METHOD         : fetch
WAL COMPRESSION     : disabled
TABLESPACE PATH(s)  :
                     16393 = /u01/app/Postgres/tablespaces
INCREMENTAL BACKUP  : ENABLED
DESCRIPTION         :

Answer 1

您将有一个选项设置

Archive_path = /u01/app/postgres/archivelogs 

在bart.cfg中，BART将采用默认路径。

archive_path (可选)-指定存储归档WAL文件的路径。归档的WAL文件的默认位置是BART备份目录( backup _path/server_name/ archived _wals)。