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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
