gs_probackup备份失败问题

问题概述

在使用磐维数据库的中，使用gs_probackup进行，使用命令如下：
gs_probackup backup -B /backup/probackup --instance=test -b PTRACK -d test_db -p 17700

在进行全量备份过程中抛出异常：pg_stop_backup doesn't answer in 300 seconds, cancel it，具体报错信息如下：

 HINT:  Check that your archive_command is executing properly.  pg_stop_backup can be canceled safely, but the database backup will not be usable without all the WAL segments.
 CONTEXT:  referenced column: lsn
 [2024-05-20 16:35:07]: keepalive message is received
 [2024-05-20 16:35:07]: keepalive message is received
 ...                                              
 [2024-05-20 16:36:02]: keepalive message is received
 WARNING: Cancel request sent
 ERROR: pg_stop_backup doesn't answer in 300 seconds, cancel it
 WARNING: Backup S5P8ZP is running, setting its status to ERROR
复制

解决方案

1、首先检查归档是否开启show archive_mode;

postgres=# show archive_mode;
 archive_mode 
--------------
 on
(1 行记录)
复制

2、归档路径是否正确show archive_dest;

postgres=# show archive_dest;
 archive_dest 
--------------
 /archive
(1 行记录)
复制

3、检查wal_sender_timeout参数配置是否配置正确

postgres=# show wal_sender_timeout ;
 wal_sender_timeout 
--------------------
 10s
(1 行记录)
复制

4、检查archive_command路径是否配置正确

5、确认是否因为备份执行命令未放置后台执行导致超时crontab -e

以上情况都检查完成，确认无误后，执行全量备份仍然报错。

根据提示archive_command去寻找目录，最后发现/archive目录的操作权限有读权限没有写入权限，将/archive目录权限通过chmod 755 /archive设置后备份成功。