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

From: Dennis Jacobfeuerborn <dennisml(at)conversis(dot)de>
To: Josef Šimánek <josef(dot)simanek(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Why would Postgres 11 suddenly ignore the recovery.conf file?
Date: 2021-10-04 10:42:20
Message-ID: b037a7b1-0b88-25e9-5de4-6e4248f21553@conversis.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

That happened with Postgres 12 I think so it shouldn't affect this
installation.

On 10/4/21 12:40, Josef Šimánek wrote:
> 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(at)conversis(dot)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
>>
>>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2021-10-04 10:43:01 Re: Why would Postgres 11 suddenly ignore the recovery.conf file?
Previous Message Josef Šimánek 2021-10-04 10:40:58 Re: Why would Postgres 11 suddenly ignore the recovery.conf file?