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

On Thursday, November 5, 2015 1:11 PM, "vijaysam(at)mailworks(dot)org" <vijaysam(at)mailworks(dot)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