Re: Interrupt

From: Mladen Gogala <mgogala(at)vmsinfo(dot)com>
To: Atif Jung <atifjung(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Interrupt
Date: 2010-05-13 01:47:24
Message-ID: 4689432.21273715241006.JavaMail.mgogala@ubuntu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Hernan Danielan 2010-05-13 05:23:03 LargeObject
Previous Message Tony Day 2010-05-12 20:05:16 Re: Get details of user locking a record?