I assumed from the user's question that the admin just wanted to stop a
specific query of a specific backend. Sending a SIGINT to the backend
will do that. I wasn't talking client request or anything like that.
Look at the description of the question below.
---
Bruce Momjian wrote:
>
> Jan Wieck wrote:
> > Bruce Momjian wrote:
> > >
> > > 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 p
Jan Wieck wrote:
> Bruce Momjian wrote:
> >
> > 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
Bruce Momjian wrote:
>
> 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 sto
On Fri, 12 Jul 2002 01:01:31 -0400 (EDT) in message
<[EMAIL PROTECTED]>, Bruce Momjian <[EMAIL PROTECTED]>
wrote:
> 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 m
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
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 ?
Thanks heaps
Rudi.
-
