| From: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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 04:25:19 |
| Message-ID: | AANLkTikUDRJ-FdD8RJYyO+btAJfE8B6MPwryA-VJ9LwU@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
On Fri, Nov 26, 2010 at 3:11 AM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> I have applied this patch, with modified wording of the "cannot connect"
> case:
>
> $ pg_ctl -w -l /dev/null start
> waiting for server to start.... done
> server started
> warning: could not connect, perhaps due to invalid authentication or
> misconfiguration.
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.
I agree to treat the receipt of password request from the server as success
of the server starting. But I don't think that we should treat other rejection
cases that way and change the existing behavior.
Regards,
--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martin Edlman | 2010-11-26 08:52:36 | Re: BUG #5770: Foreign key violation after insert |
| Previous Message | Shafqat Ali | 2010-11-26 03:21:52 | BUG #5771: C:\Program Files\PostgreSQL\8.3\Data is not accessible. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-11-26 06:02:25 | Re: [JDBC] JDBC and Binary protocol error, for some statements |
| Previous Message | Shigeru HANADA | 2010-11-26 04:06:58 | Re: SQL/MED - file_fdw |