Re: BUG #13757: Able to write to postgres even when the main process has been killed

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