Re: Quit currently running query

2023-02-28 Thread Ron
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 s

Re: Quit currently running query

2023-02-28 Thread Peter J. Holzer
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

Re: Quit currently running query

2023-02-28 Thread Rob Sargent
On 2/28/23 03: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? can you open another psql session to your server?

Re: Quit currently running query

2023-02-28 Thread Ron
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" /reall

Re: Quit currently running query

2023-02-28 Thread Ian Lawrence Barwick
2023年2月28日(火) 22:30 Albert Cornelius : > > 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? See here: https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL Regar

Quit currently running query

2023-02-28 Thread Albert Cornelius
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?