Rudi Starcevic wrote: > Hello, > > If I write a query that is inefficient or in an eternal loop how > do I stop it without restarting the postmaster ? > > I can see many postmaster processed appearing in the output of the 'ps' > command. > Do I need to stop/kill them all or can I stop just the query I want ?
Just send a SIGINT to the process. That simulates a ^C, which works too from the client like psql. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
