Re: Backend process is still runs even postmaster got killed

On Fri, Dec 7, 2012 at 10:21 AM, Alvaro Herrera
<alvherre(at)2ndquadrant(dot)com> wrote:
>>Hari Babu wrote:
>> Backend processes are still running even if the postmaster got killed and
>> all other server processes are exited by checking the
>>
>> Postmaster status.

>What server version?

I had tested it in 9.3 devel and 9.2 as well.
I tested as follows.

./pg_ctl -D data start
./psql postgres

In another terminal kill the postmaster with kill -9 PID.
Now start using the psql which is already connected, it can execute all
queries.
And check the server processes (ps -elf | grep postgres) only backend
process will remain.

I know postmaster crash is a very rare scenario, If backend continuously
providing the service,
I want to know what are all the problems can occur?

Regards,
Hari babu.