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

From: Josef Šimánek <josef(dot)simanek(at)gmail(dot)com>
To: Dennis Jacobfeuerborn <dennisml(at)conversis(dot)de>
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:40:58
Message-ID: CAFp7QwrDQM=6hxeRoF4AQATrVydBXqkK1ujCvhH1OZtTJmgHpQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Jacobfeuerborn 2021-10-04 10:42:20 Re: Why would Postgres 11 suddenly ignore the recovery.conf file?
Previous Message Shaozhong SHI 2021-10-04 10:40:35 How to set up temporary path for starting up psql in any folder?