Re: About pg_basebackup

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: About pg_basebackup
Дата
Msg-id CAKFQuwYGTio50YxkUaV5TpvLCM1sXQ8uxnwSfxRmECJJW4T0Jg@mail.gmail.com
обсуждение исходный текст
Ответ на About pg_basebackup  (菊池祐 <y.kikuchi0714@gmail.com>)
Ответы Re: About pg_basebackup  (菊池祐 <y.kikuchi0714@gmail.com>)
Список pgsql-bugs
On Wed, May 18, 2022 at 8:35 PM 菊池祐 <y.kikuchi0714@gmail.com> wrote:

Hi,

I executed the pg_basebackup command to set up a replication configuration in postgresql, but the following message appears and replication didn’t complete.

2741/2742 tablespaces (/var/lib/pgsql/9.2/bac12609150596/12609150596 kB (100%), 2741/2742 tablespaces (/var/lib/pgsql/9.2/bac12609150596/12609150596 kB (100%), 2742/2742 tablespaces 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) ・ ・ ・

Please let me know how to deal with this.


Impossible to say with the information provided.  The PostgreSQL log file during this period should prove informative.  You have an archive_command set so look for any messages indicating it is failing (just like the HINT says...)

What specific version of the long unsupported version 9.2.x are you running?

This seems unlikely to be a bug.  Support questions are more appropriately directed to the pgsql-general mailing list.

David J.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: 菊池祐
Дата:
Сообщение: About pg_basebackup
Следующее
От: 菊池祐
Дата:
Сообщение: Re: About pg_basebackup