Re: Backend process is still runs even postmaster got killed - Mailing list pgsql-general

From Hari Babu
Subject Re: Backend process is still runs even postmaster got killed
Date
Msg-id 002601cdd488$03dcb890$0b9629b0$@kommi@huawei.com
Whole thread Raw
In response to Re: Backend process is still runs even postmaster got killed  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-general
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.





pgsql-general by date:

Previous
From: Igor Neyman
Date:
Subject: Re: unlooged tables
Next
From: wd
Date:
Subject: How to find which query a waiting query waiting for?