Re: Quit currently running query

From: Ian Lawrence Barwick <barwick(at)gmail(dot)com>
To: Albert Cornelius <albert1(dot)cornelius(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Quit currently running query
Date: 2023-02-28 13:41:42
Message-ID: CAB8KJ=iaR54ZrVOAhVzxvDG8_r5ivO1iuh7fDpxH9ZdBNcMX1A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2023年2月28日(火) 22:30 Albert Cornelius <albert1(dot)cornelius(at)gmail(dot)com>:
>
> 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

Regards

Ian Barwick

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2023-02-28 13:42:08 Re: Quit currently running query
Previous Message Eugene M. Zheganin 2023-02-28 11:08:47 13.x, stream replication and locale(?) issues