From: | Thalis Kalfigkopoulos <tkalfigo(at)gmail(dot)com> |
---|---|
To: | Hari Babu <haribabu(dot)kommi(at)huawei(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Backend process is still runs even postmaster got killed |
Date: | 2012-12-07 13:56:19 |
Message-ID: | CAEkCx9EUC4fYbLnmMHaZP6W_W=a_B1s1cpgRx9-NRMzTtbC-Tw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Dec 7, 2012 at 10:21 AM, Hari Babu <haribabu(dot)kommi(at)huawei(dot)com>wrote:
> Backend processes are still running even if the postmaster got killed and
> all other server processes are exited by checking the****
>
> Postmaster status. ****
>
> ** **
>
> And the backend process is providing the service to the client.****
>
> Is there any problems are possible? If we continue the system for a long
> time with the above behavior?****
>
> ** **
>
> Until all these kind of backend processes are exited, postmaster is
> failing to start.****
>
> Manual cleanup is required for these backend processes? Or is there anyway
> we can handle?****
>
> ** **
>
> Regards,****
>
> Hari babu.****
>
>
>
Hi Hari.
How exactly do you kill the postmaster? It is suggested you use pg_ctl for
server shutdowns/restarts. Check out the option -m:
-m SHUTDOWN-MODE can be "smart", "fast", or "immediate"
Shutdown modes are:
smart quit after all clients have disconnected
fast quit directly, with proper shutdown
immediate quit without complete shutdown; will lead to recovery on
restart
"Smart" will wait for all your backend processes to terminate (or fail if
it takes too long). If i remember correctly "fast" will cause the
postmaster to exit even if backends are still up, the equivalent of sending
a kill -15 (SIGTERM). And "immediate" is like sending a kill -9 (SIGKILL)
i.e. violent shutdown of everything.
I'm guessing you went for the equivalent of SIGTERM that's why you still
have backends running.
regards,
--thalis
From | Date | Subject | |
---|---|---|---|
Next Message | Hari Babu | 2012-12-07 14:15:11 | Re: Backend process is still runs even postmaster got killed |
Previous Message | Hari Babu | 2012-12-07 13:21:31 | Backend process is still runs even postmaster got killed |