Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pX24I-0005hZ-7Q for pgsql-general@arkaria.postgresql.org; Tue, 28 Feb 2023 15:39:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pX24G-0004fU-3S for pgsql-general@arkaria.postgresql.org; Tue, 28 Feb 2023 15:39:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pX24F-0004fL-M0 for pgsql-general@lists.postgresql.org; Tue, 28 Feb 2023 15:39:03 +0000 Received: from mail-pl1-x62d.google.com ([2607:f8b0:4864:20::62d]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pX24D-00073e-EU for pgsql-general@lists.postgresql.org; Tue, 28 Feb 2023 15:39:03 +0000 Received: by mail-pl1-x62d.google.com with SMTP id p6so10018591plf.0 for ; Tue, 28 Feb 2023 07:39:00 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=aoZSxPEXfmrq00FbPsUz4QWflf2epzUnlD3z9juKztE=; b=T/lhWqjZFL0/X165IWfUgfyzkYry9dm2De0pGkygVunEgsaafOptOlaONo1MXJnxkb YTAyIU9qLVpNyBQsDbE5utPjB2RFLHLYGMDMH6Tw7BubigHHxU2wG5aWRwqfRaxV1e1l 3oPRcttseWmS7hdgTmphXwq+fW7kkgkknk2YH07dyUXSDywWUXU4lNjygwBol5F3jGW2 KRq8wYf+udjZvaadnl5bgWgqicQ3o6kabZThCrlPbPGJruB30sk3P8bD2LflP26pRVHF 0c92q/UCvSEqDBFvnK5jHUqeZdfCSGWo6zEW+MhoqgWrkWXo9NfkWBLCaHfn3VyKjmdx 1eRg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=aoZSxPEXfmrq00FbPsUz4QWflf2epzUnlD3z9juKztE=; b=FVUexTcGlPJwXnp643a56u+yhlcNr54djUASHJ3CrvJpocyA7WUfuttFiN9x/+HrqC G0x+2jaNOe1CAV5OP1fFB7ILx/3BmMPUjFhufo/W9oaQvvTAvamwOruiB7WhOEJdWKwj hTn5k2uroQcAmXYd7ibLe1wcb1CmCYj1WJ+6v0qSmTN/z+jUcVB9TFgA5l0sdHjssvAl +SPREYeBlfG6aRwMvfmJCodFzL33xZNOrg/PoHONnT67QIx0nFKvlx8QLM1KV8wbHUmv MAgVcvGRrpteuhgBNL5M47XRW69sM84NkOYGSyH0IrK66SzB8zi4iHtCaEc/kxpTo06a 42Uw== X-Gm-Message-State: AO0yUKV4Sjz1wcMmGTg0uIElZEUBTeLTYXaoaXE+3WmHGgqQyy9MyuV4 /aMhMUiAngWBW1O5s1Bit99g4DjuR4YHng== X-Google-Smtp-Source: AK7set+5VLRxrxkm6RAu5RhEqbg0M/puj9qT2ebD7pA1VYMbJNZxxIS/0Ddb4nmeTDd9NGcAtaCsBw== X-Received: by 2002:a17:902:b498:b0:19d:2542:96b7 with SMTP id y24-20020a170902b49800b0019d254296b7mr2598798plr.39.1677598738454; Tue, 28 Feb 2023 07:38:58 -0800 (PST) Received: from ?IPV6:2601:681:5a00:f790:6a84:98d8:eefd:dc73? ([2601:681:5a00:f790:6a84:98d8:eefd:dc73]) by smtp.gmail.com with ESMTPSA id q4-20020a170902bd8400b0019e32dae437sm1574330pls.14.2023.02.28.07.38.57 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 28 Feb 2023 07:38:58 -0800 (PST) Content-Type: multipart/alternative; boundary="------------HFa0OawJ2qrzTtGZLLZb7LVU" Message-ID: <4893b4b7-b96b-cd1d-7bbe-9ff6bb9e9f67@gmail.com> Date: Tue, 28 Feb 2023 08:38:56 -0700 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.7.1 Subject: Re: Quit currently running query Content-Language: en-CA To: pgsql-general@lists.postgresql.org References: From: Rob Sargent In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------HFa0OawJ2qrzTtGZLLZb7LVU Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit 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? --------------HFa0OawJ2qrzTtGZLLZb7LVU Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit
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?
--------------HFa0OawJ2qrzTtGZLLZb7LVU--