Re: BUG #13757: Able to write to postgres even when the main process has been killed - Mailing list pgsql-bugs

From Vijayakumar Krishnan
Subject Re: BUG #13757: Able to write to postgres even when the main process has been killed
Date
Msg-id 1446841108.1072310.431374745.49CE3C2B@webmail.messagingengine.com
Whole thread Raw
In response to Re: BUG #13757: Able to write to postgres even when the main process has been killed  (Kevin Grittner <kgrittn@ymail.com>)
Responses Re: BUG #13757: Able to write to postgres even when the main process has been killed  (Haribabu Kommi <kommi.haribabu@gmail.com>)
List pgsql-bugs
Yes just did a fresh build of 9.4.5 from source and tried the same test.
Seems the problem still exists.

Thanks,
-vijay

On Fri, Nov 6, 2015, at 09:31 PM, Kevin Grittner wrote:
> On Thursday, November 5, 2015 1:11 PM, "vijaysam@mailworks.org"
> <vijaysam@mailworks.org> wrote:
>
> > Postgres 9.4.1
>
> http://www.postgresql.org/support/versioning/
>
> > when I try to kill -9 the master server main postgres process.
> > The client code from java is able to continue to write to the
> > postgres db which was the old master as there was a connection
> > established to this server and the connection keeps allowing
> > write to happen as thought the server is still running.
>
> Before reporting a bug it is a good idea to check whether a fix for
> it is available.  Version 9.4.5 includes this:
>
> | * Ensure that the postmaster does not exit until all its child
> |   processes are gone, even in an immediate shutdown (Tom Lane)
> |
> |   Like the previous item, this avoids possible race conditions
> |   against a subsequently-started postmaster.
>
>
> Do you still see the problem when running with fixes for the known
> bugs?
>
> --
> Kevin Grittner
> EDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company

pgsql-bugs by date:

Previous
From: Robert Haas
Date:
Subject: Re: [HACKERS] BUG #12989: pg_size_pretty with negative values
Next
From: Haribabu Kommi
Date:
Subject: Re: BUG #13757: Able to write to postgres even when the main process has been killed