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

Hi,

Thank you all for suggestions.
I've just disabled hot_standby and restarted server. Everything is OK now.

I assume there was continuous recovery mode.

You cannot modify the database, right?
>
No, I can. As long it was in this recovery mode with hot_standby=on I was
able query and modify database, with hot_standby=off I couldn't even
connect.
Here is another my wonder: relying on manual, it had to be read-only mode.

And "SELECT pg_is_in_recovery();" returns TRUE, right?

I don't know :( Can't check it anymore. May be.
That is the question: If I can't connect with "FATAL: the database system
is starting up" how I can check pg_is_in_recovery()?
What else I could check to ensure that postgres recovering databases and I
just have to wait?
I was strongly confused by NO CPU and HDD activity during my wait.

So my conclusion is:
If postgres says "FATAL: the database system is starting up" after
failure without any other errors in logs and postgres output, than you can:
- wait for some long period of time
or
- you can turn on hot_standby and use your database with care while
it's recovering and turn hot_standby off when it finishes.

Hoping this thread helps someone sometime.