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

Поиск
Список
Период
Сортировка
От Dennis Jacobfeuerborn
Тема Why would Postgres 11 suddenly ignore the recovery.conf file?
Дата
Msg-id d23b6955-8891-22cc-5d59-a9582892af50@conversis.de
обсуждение исходный текст
Ответы Re: Why would Postgres 11 suddenly ignore the recovery.conf file?  (Josef Šimánek <josef.simanek@gmail.com>)
Re: Why would Postgres 11 suddenly ignore the recovery.conf file?  (hubert depesz lubaczewski <depesz@depesz.com>)
Re: Why would Postgres 11 suddenly ignore the recovery.conf file?  (Dennis Jacobfeuerborn <dennisml@conversis.de>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Vijay Garg
Дата:
Сообщение: Re: Problem in Storing Satellite imagey(Geotiff file)
Следующее
От: Shaozhong SHI
Дата:
Сообщение: How to set up temporary path for starting up psql in any folder?