Thread: Quit currently running query
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?
2023年2月28日(火) 22:30 Albert Cornelius <albert1.cornelius@gmail.com>: > > How can I quit a currently running query? I've issued a query and my server does not respond anymore. Is there anothersolution than using kill -9? See here: https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL Regards Ian Barwick
On 2/28/23 04:53, Albert Cornelius wrote:
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".
I'd first try "
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".
I'd first try "
select pg_cancel_backend(<pid>);". If that doesn't work, try "select pg_terminate_backend(<pid>);"--
Born in Arizona, moved to Babylonia.
Born in Arizona, moved to Babylonia.
On 2/28/23 03:53, Albert Cornelius wrote:
can you open another psql session to your server?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?
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.
hp
--
_ | Peter J. Holzer | Story must make more sense than reality.
|_|_) | |
| | | hjp@hjp.at | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
Attachment
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.