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.