Re: Quit currently running query
От | Ron |
---|---|
Тема | Re: Quit currently running query |
Дата | |
Msg-id | b2a34d55-1a10-b359-36ab-93530f942870@gmail.com обсуждение исходный текст |
Ответ на | Re: Quit currently running query ("Peter J. Holzer" <hjp-pgsql@hjp.at>) |
Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: