O pg_basebackup do Postgres nunca termina de criar backup

Question

Estou tentando mover arquivos para outro servidor para configurar um escravo. Eu tenho um banco de dados em um servidor Postgres e estou tentando criar um backup baseado em arquivo usando pg_backup. No entanto, nunca termina de executar o comando.

Aqui está a saída:

    /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.

Eu corri isso por horas a fio, e isso nunca termina. O banco de dados é de cerca de 11 GB.

Alguma ideia de por que isso pode falhar e onde posso encontrar erros?

    

Answer 1

Parece que o seu archive_command , que está configurado em postgresql.conf está falhando. Nós não podemos ajudá-lo mais - por favor, forneça mais informações, pelo menos, qual é o seu valor?