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

From Kevin Grittner
Subject Re: BUG #13757: Able to write to postgres even when the main process has been killed
Date
Msg-id 1800885278.731274.1446827519471.JavaMail.yahoo@mail.yahoo.com
Whole thread Raw
In response to BUG #13757: Able to write to postgres even when the main process has been killed  (vijaysam@mailworks.org)
Responses Re: BUG #13757: Able to write to postgres even when the main process has been killed  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: BUG #13757: Able to write to postgres even when the main process has been killed  (Vijayakumar Krishnan <vijaysam@mailworks.org>)
List pgsql-bugs
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: Alvaro Herrera
Date:
Subject: Re: BUG #13757: Able to write to postgres even when the main process has been killed