On Thursday, December 27, 2012 2:44 PM Harry wrote:
> Below is the Linux ps -ef | grep postgres output :-
>
> 501 12163 5473 0 Dec19 ? 00:00:00 postgres: enterprisedb
> sampledb 192.168.0.231[53991] ?EDB-SPL Procedure successfully completed
> 501 12167 5473 0 Dec19 ? 00:00:00 postgres: enterprisedb
> sampledb 192.168.0.231[53995] ?EDB-SPL Procedure successfully
> completed.
>
> Also, if i try to kill from OS the whole database gets shut down.
Have you checked server logs for any specific messages like below or any
other message after you call cancel/terminate
Backend API?
FATAL: terminating connection due to administrator command
ERROR: canceling statement due to user request
With Regards,
Amit Kapila.