Re: Why would Postgres 11 suddenly ignore the recovery.conf file?

Поиск
Список
Период
Сортировка
От Josef Šimánek
Тема Re: Why would Postgres 11 suddenly ignore the recovery.conf file?
Дата
Msg-id CAFp7QwrDQM=6hxeRoF4AQATrVydBXqkK1ujCvhH1OZtTJmgHpQ@mail.gmail.com
обсуждение исходный текст
Ответ на Why would Postgres 11 suddenly ignore the recovery.conf file?  (Dennis Jacobfeuerborn <dennisml@conversis.de>)
Ответы Re: Why would Postgres 11 suddenly ignore the recovery.conf file?  (Dennis Jacobfeuerborn <dennisml@conversis.de>)
Список pgsql-general
Isn't this related to merge into postgresql.conf
(https://www.postgresql.org/docs/current/recovery-config.html)?

po 4. 10. 2021 v 12:35 odesílatel Dennis Jacobfeuerborn
<dennisml@conversis.de> napsal:
>
> Hi,
> I just stopped and restarted a Postgres 11 docker container which so far
> has happily streamed the WAL from its primary but after the restart it
> now seems to completely ignore the recovery.conf file and just outputs this:
>
>   2021-10-04 10:14:19.103 UTC [1] LOG:  listening on IPv4 address
> "0.0.0.0", port 5432
> 2021-10-04 10:14:19.103 UTC [1] LOG:  listening on IPv6 address "::",
> port 5432
> 2021-10-04 10:14:19.123 UTC [1] LOG:  listening on Unix socket
> "/var/run/postgresql/.s.PGSQL.5432"
> 2021-10-04 10:14:19.304 UTC [21] LOG:  database system was shut down in
> recovery at 2021-10-04 10:14:11 UTC
> 2021-10-04 10:14:19.305 UTC [21] LOG:  entering standby mode
> 2021-10-04 10:14:19.313 UTC [21] LOG:  could not signal for checkpoint:
> checkpointer is not running
> 2021-10-04 10:14:19.338 UTC [21] LOG:  redo starts at 2F01/B9044C30
> 2021-10-04 10:15:35.889 UTC [21] LOG:  consistent recovery state reached
> at 2F02/A2E1A108
> 2021-10-04 10:15:35.893 UTC [1] LOG:  database system is ready to accept
> read only connections
>
> Notice that there is apparently no attempt being made to connect to the
> primary any more. The recovery.conf file is still present and correct so
> I don't understand why Postgres seems to ignore it completely?
>
> Regards,
>    Dennis
>
>



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

Предыдущее
От: Shaozhong SHI
Дата:
Сообщение: How to set up temporary path for starting up psql in any folder?
Следующее
От: Dennis Jacobfeuerborn
Дата:
Сообщение: Re: Why would Postgres 11 suddenly ignore the recovery.conf file?