Re: Cursor fetch Problem.

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.