Re: Interrupt - Mailing list pgsql-novice

From Atif Jung
Subject Re: Interrupt
Date
Msg-id AANLkTil9Q_ZNwYBQXH78vm_oh-vkp3vrgo2ytiyEjaML@mail.gmail.com
Whole thread Raw
In response to Re: Interrupt  (Mladen Gogala <mgogala@vmsinfo.com>)
List pgsql-novice
Sorry I should have added that I need to do this within ECPG.
Atif




On 13 May 2010 02:47, Mladen Gogala <mgogala@vmsinfo.com> wrote:
Interrupt the server? Well, Monzy sang about that at one time, but depending on where are you executing the SQL statement from, SIGINT to the front end will usually do the trick. The "init 6" command, executed as user "root", should also be able to interrupt the server and the on-going SQL, as well as everything else. It's the reboot command.

----- Original Message -----
From: "Atif Jung" <atifjung@gmail.com>
Sent: Wednesday, May 12, 2010 9:31:09 AM GMT -05:00 US/Canada Eastern
Subject: [NOVICE] Interrupt


How do I interrupt the database server and cancel any SQL statement currently running?

Thanks

Atif

--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com


pgsql-novice by date:

Previous
From: Rob Northcott
Date:
Subject: Re: Get details of user locking a record?
Next
From: Ivan Uemlianin
Date:
Subject: connecting from trac: "no route to host" error