Re: About pg_basebackup

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: About pg_basebackup
Дата
Msg-id 34e97beb7f8e2afbe463b42dced0d6b73364e568.camel@cybertec.at
обсуждение исходный текст
Ответ на About pg_basebackup  (菊池祐 <y.kikuchi0714@gmail.com>)
Список pgsql-general
On Thu, 2022-05-19 at 13:18 +0900, 菊池祐 wrote:
> 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/12609150596kB (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
backupwill 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)

I guess that your "archive_command" is hanging or failing.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com



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

Предыдущее
От: 菊池祐
Дата:
Сообщение: About pg_basebackup
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: In case of network issues, how long before archive_command does retries