☰

Postgres 的 pg_basebackup 从未完成创建备份

tag-icon • tag-icon postgresql
Postgres 的 pg_basebackup 从未完成创建备份

我正在尝试将文件移动到另一台服务器以设置从属服务器。我在一台 Postgres 服务器上有一个数据库，并尝试使用 pg_backup 创建基于文件的备份。但是，它始终无法完成命令的执行。

输出如下：

    /usr/pgsql-9.2/bin/pg_basebackup -U postgres -D - -P -Ft  > pg_backup.backup
    11247472/11247472 kB (100%), 1/1 tablespace
    NOTICE:  pg_stop_backup cleanup done, waiting for required WAL segments to be archived
    WARNING:  pg_stop_backup still waiting for all required WAL segments to be archived (60 seconds elapsed)
    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.
    WARNING:  pg_stop_backup still waiting for all required WAL segments to be archived (120 seconds elapsed)
    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.
    WARNING:  pg_stop_backup still waiting for all required WAL segments to be archived (240 seconds elapsed)
    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.
    WARNING:  pg_stop_backup still waiting for all required WAL segments to be archived (480 seconds elapsed)
    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.
    WARNING:  pg_stop_backup still waiting for all required WAL segments to be archived (960 seconds elapsed)
    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.

我已经连续运行了几个小时，但始终无法完成。数据库大约有 11GB。

知道为什么这可能会失败以及我可以在哪里找到错误吗？

答案1

看起来您archive_command在 中配置的postgresql.conf失败了。我们无法为您提供更多帮助 — 请提供更多信息，至少它的值是多少？

相关内容