Re: [GENERAL] pg_ctl kill QUIT

2012-07-30 Thread Craig Ringer
On 07/30/2012 05:52 PM, Venkat Balaji wrote: Hello Community, We have used "pg_ctlkill QUIT " to terminate one of the processes on the production database and the database went into recovery mode. Did you intend to send SIGTERM (signal 15) instead of SIGQUIT (signal 3)? Signal 3 will be inte

[GENERAL] pg_ctl kill QUIT

2012-07-30 Thread Venkat Balaji
Hello Community, We have used "pg_ctl kill QUIT " to terminate one of the processes on the production database and the database went into recovery mode. We understand that we should not use "kill -9" and we did not do that. Could you please help us avoid this problem permanently. Regards, Venka