"FATAL: the database system is starting up" and hot_standby = on

From: Ilnur Khanov <khanov(dot)i(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: "FATAL: the database system is starting up" and hot_standby = on
Date: 2017-12-07 05:49:16
Message-ID: CAN+PxfQwWM5j4LvJNV1jERuvLV4x-Oi6w6JKQadPft_AztQBfQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

There is a standalone server with Postgresql 9.6.3 on Windows 2016 Server.

I had been faced with "FATAL: the database system is starting up" after
disk failure. This mailing list helped me to solve issue by setting
"hot_standby = on" in postgresql.conf.
But I can't fully understand why it had worked.

Comments in conf says, that the setting has to be ignored in my case:
===
# - Standby Servers -
# These settings are ignored on a master server.
hot_standby = on # "on" allows queries during recovery
# (change requires restart)
===

But it is standalone installation, not slave, there is no replication.
Though there is no recovery.conf and any sign of pending recovery nor in
log, nor in postgres.exe output with debug level 5.

Why setting "hot_standby = on" had helped me with "FATAL: the database
system is starting up" error on standalone server? Any ideas?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David Guyot 2017-12-07 08:11:58 Re: "FATAL: the database system is starting up" and hot_standby = on
Previous Message mail 2017-12-05 14:30:23 Docker Image