Re: Nicer error when connecting to standby with hot_standby=off

From: Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: James Coleman <jtc331(at)gmail(dot)com>, Magnus Hagander <magnus(at)hagander(dot)net>, David Steele <david(at)pgmasters(dot)net>, David Zhang <david(dot)zhang(at)highgo(dot)ca>, PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Nicer error when connecting to standby with hot_standby=off
Date: 2021-03-24 01:46:21
Message-ID: e72cc9a0-ee5b-aff6-4aa0-821821499ee8@oss.nttdata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2021/03/24 5:59, Tom Lane wrote:
> Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> writes:
>> FATAL: the database system is starting up
>> DETAIL: WAL is being applied to recover from a system crash.
>> or
>> DETAIL: The system is applying WAL to recover from a system crash.
>> or
>> DETAIL: The startup process is applying WAL to recover from a system crash.
>
> I don't think the postmaster has enough context to know if that's
> actually true. It just launches the startup process and waits for
> results. If somebody saw this during a normal (non-crash) startup,
> they'd be justifiably alarmed.

Yes, so logging "the database system is starting up" seems enough to me.

Regards,

--
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2021-03-24 02:43:59 Re: New IndexAM API controlling index vacuum strategies
Previous Message Fujii Masao 2021-03-24 01:41:20 Re: PostmasterIsAlive() in recovery (non-USE_POST_MASTER_DEATH_SIGNAL builds)