| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, Magnus Hagander <magnus(at)hagander(dot)net>, Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>, Mark Llewellyn <mark_llewellyn(at)adp(dot)com>, pgsql-hackers(at)postgresql(dot)org, Sujeet Rajguru <sujeet(dot)rajguru(at)enterprisedb(dot)com> |
| Subject: | Re: Re: [BUGS] BUG #5650: Postgres service showing as stopped when in fact it is running |
| Date: | 2010-11-26 20:39:33 |
| Message-ID: | 16039.1290803973@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
Bruce Momjian <bruce(at)momjian(dot)us> writes:
> Fujii Masao wrote:
>> This patch breaks the behavior that "pg_ctl -w start" waits until the standby
>> has been ready to accept read-only queries. IOW, pg_ctl without this patch
>> continues to check the connection even if the connection is rejected because
>> the database has not been consistent yet. But pg_ctl with this patch treats
>> that rejection as success of the standby starting and prints the above
>> messages.
The reason this is a problem is that somebody, in a fit of inappropriate
optimization, took out the code that allowed canAcceptConnections to
distinguish the "not consistent yet" state. We need to put that back,
not try to kluge around the problem from the client side.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-11-26 23:30:03 | Re: Re: [BUGS] BUG #5650: Postgres service showing as stopped when in fact it is running |
| Previous Message | Tom Lane | 2010-11-26 20:30:49 | Re: Re: [BUGS] BUG #5650: Postgres service showing as stopped when in fact it is running |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2010-11-26 20:43:50 | Re: ToDo: enhanced diagnostic for plpgsql |
| Previous Message | Tom Lane | 2010-11-26 20:30:49 | Re: Re: [BUGS] BUG #5650: Postgres service showing as stopped when in fact it is running |