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

Поиск
Список
Период
Сортировка
От Ilnur Khanov
Тема "FATAL: the database system is starting up" and hot_standby = on
Дата
Msg-id CAN+PxfQwWM5j4LvJNV1jERuvLV4x-Oi6w6JKQadPft_AztQBfQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: "FATAL: the database system is starting up" and hot_standby = on  (David Guyot <david.guyot@europecamions-interactive.com>)
Список 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?

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

Предыдущее
От: mail@mcnesium.com
Дата:
Сообщение: Docker Image
Следующее
От: David Guyot
Дата:
Сообщение: Re: "FATAL: the database system is starting up" and hot_standby = on