Skip site navigation (1) Skip section navigation (2)

Re: Interrupt

From: Atif Jung <atifjung(at)gmail(dot)com>
To: Mladen Gogala <mgogala(at)vmsinfo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Interrupt
Date: 2010-05-13 10:30:22
Message-ID: AANLkTil9Q_ZNwYBQXH78vm_oh-vkp3vrgo2ytiyEjaML@mail.gmail.com (view raw or flat)
Thread:
Lists: 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(at)vmsinfo(dot)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(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
>
>

In response to

pgsql-novice by date

Next:From: Ivan UemlianinDate: 2010-05-13 14:15:30
Subject: connecting from trac: "no route to host" error
Previous:From: Rob NorthcottDate: 2010-05-13 08:46:51
Subject: Re: Get details of user locking a record?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group