From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: Quit currently running query
Date: Tue, 28 Feb 2023 12:22:47 -0600
Message-ID: <b2a34d55-1a10-b359-36ab-93530f942870@gmail.com> (raw)
In-Reply-To: <20230228173145.hkyrsoqicyyjg7bx@hjp.at>
References: <CAHGzHmTqMBdE-M4tbffG_eFD0W_rH_fDgmzbYQ+oLOsvQynYkg@mail.gmail.com>
<c85d3f88-96db-c4cb-f2a9-33ee4cc71266@gmail.com>
<20230228173145.hkyrsoqicyyjg7bx@hjp.at>
On 2/28/23 11:31, Peter J. Holzer wrote:
> On 2023-02-28 07:42:08 -0600, Ron wrote:
>> On 2/28/23 04:53, Albert Cornelius wrote:
>>
>> How can I quit a currently running query? I've issued a query and
>> my server does not respond anymore. Is there another solution than
>> using kill -9?
>>
>>
>> What specifically do you mean by "my server does not respond
>> anymore"? Because if "the server" really doesn't respond anymore, you
>> can't even issue "kill -9".
> The term "server" can mean different things:
>
> 1) A role in an interaction between two programs. The "client" is the one
> which issues requests, and the "server" is the one which fullfills
> them.
>
> 2) A program which is intended for the server role. Note that a program
> can be a server for one protocol and a client for another (e.g., a
> database server can be a DNS or LDAP client). (And some programs are
> even server and client for the same protocol)
>
> 3) A machine intended for running server programs.
>
> You are thinking of the 3rd meaning. My guess is that Albert meant the
> first.
And maybe he's referring to his client software... That's why I asked him
for clarification.
--
Born in Arizona, moved to Babylonia.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: ronljohnsonjr@gmail.com
Subject: Re: Quit currently running query
In-Reply-To: <b2a34d55-1a10-b359-36ab-93530f942870@gmail.com>
References: <CAHGzHmTqMBdE-M4tbffG_eFD0W_rH_fDgmzbYQ+oLOsvQynYkg@mail.gmail.com> <c85d3f88-96db-c4cb-f2a9-33ee4cc71266@gmail.com> <20230228173145.hkyrsoqicyyjg7bx@hjp.at> <b2a34d55-1a10-b359-36ab-93530f942870@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox