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 <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1l0KrE-0005Qn-HM
	for pgsql-hackers@arkaria.postgresql.org; Fri, 15 Jan 2021 08:53:24 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1l0KrC-00050n-9r
	for pgsql-hackers@arkaria.postgresql.org; Fri, 15 Jan 2021 08:53:22 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <peter.eisentraut@enterprisedb.com>)
	id 1l0KrB-00050g-Un
	for pgsql-hackers@lists.postgresql.org; Fri, 15 Jan 2021 08:53:21 +0000
Received: from [66.111.4.238] (helo=forward4-smtp.messagingengine.com)
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <peter.eisentraut@enterprisedb.com>)
	id 1l0Kr8-0005mT-PG
	for pgsql-hackers@lists.postgresql.org; Fri, 15 Jan 2021 08:53:20 +0000
Received: from compute3.internal (compute3.nyi.internal [10.202.2.43])
	by mailforward.nyi.internal (Postfix) with ESMTP id DC54519C3B1C;
	Fri, 15 Jan 2021 03:53:07 -0500 (EST)
Received: from mailfrontend2 ([10.202.2.163])
  by compute3.internal (MEProxy); Fri, 15 Jan 2021 03:53:07 -0500
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:content-transfer-encoding:content-type
	:date:from:in-reply-to:message-id:mime-version:references
	:subject:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender
	:x-sasl-enc; s=fm1; bh=49Ofdew1tLGalb2mjnepRssTVv4N4JeMU77MxL+Gc
	CY=; b=Q8d/NlHHlwwhlkEQMadEKswkc2XMYvMDtVtgLRmaGhZJPO3YX8Uia2mAb
	gA+ce5YCjhkiZBa4XYv2qrMXAJh5l0mmbX3TyrE1rwKlS29gackkBzVrRJpkJFzG
	CyuNLZuMB6YZWZUwrQ0EmfPHtDR2sa0mnziaZLczUPGC0OlDxvDjT9HUCYKPfSk2
	ygK4JTTpVzEOvP/SC4QnnunIZ+mvRSsNIo4VsZPn20cH5+2OEOC8l1Auua2tE6nv
	7H8IHEW2oFDBfpchCdNn6ojEFbVTC5lbNKSWN+KEV+9qWpWS9w4EWMkqWQB+SgRU
	ZcVOB66JH67nrScPOgern7zzx7KvA==
X-ME-Sender: <xms:81cBYEKRKbgyyUC-gWScESKS7-3Hx4HoTXWTut60pVuO9PN1QYKx3w>
    <xme:81cBYEJBAi_jIZZ6Kpz1lsCkV_eVAYOhWOljx1cydDx4xAPf9XpnjBluvyjFiuTLJ
    cE1uWmMXcIkY47Axw>
X-ME-Proxy-Cause: 
 gggruggvucftvghtrhhoucdtuddrgeduledrtddugdduvdehucetufdoteggodetrfdotf
    fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen
    uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne
    cujfgurhepuffvfhfhohfkffgfgggjtgfgsehtjeertddtfeejnecuhfhrohhmpefrvght
    vghrucfgihhsvghnthhrrghuthcuoehpvghtvghrrdgvihhsvghnthhrrghuthesvghnth
    gvrhhprhhishgvuggsrdgtohhmqeenucggtffrrghtthgvrhhnpeehheeijefgvefhvdeh
    leekueevhfehhedvheetgffhteefgeeggfevjeejfffgvdenucfkphepkeejrddujeejrd
    ejvddrudegvdenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhr
    ohhmpehpvghtvghrrdgvihhsvghnthhrrghuthesvghnthgvrhhprhhishgvuggsrdgtoh
    hm
X-ME-Proxy: <xmx:81cBYEttz2ZI_YMMXTn_BMrphBSzH64ioOuhyP_t3Kh325h9tawYIA>
    <xmx:81cBYBZXijI2QvIyBzBian4qRTV_np_QqQbBWuRY4hg60sQli-Ey9A>
    <xmx:81cBYLacsGcq2txqpqGnV56mX3xdZdH3TjjiFiSoCNbcr88I73-dSw>
    <xmx:81cBYITI74fY4QfUn-t8tLGzwZ8Jq2zRx2Lu7c4dy-6MdjGQNh-GAQ>
Received: from april.pezone.net (p57b1488e.dip0.t-ipconnect.de
 [87.177.72.142])
	by mail.messagingengine.com (Postfix) with ESMTPA id BEBA4108005C;
	Fri, 15 Jan 2021 03:53:06 -0500 (EST)
Subject: Re: Printing backtrace of postgres processes
To: vignesh C <vignesh21@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>
References: 
 <CALDaNm3ZzmFS-=r7oDUzj7y7BgQv+N06Kqyft6C3xZDoKnk_6w@mail.gmail.com>
 <1778088.1606026308@sss.pgh.pa.us>
 <20201201032649.aekv5b5dicvmovf4@alap3.anarazel.de>
 <1361750.1606795285@sss.pgh.pa.us>
 <CALDaNm0pUzawA96LjKohn8eF2BSxkZMRvO70M1-bcbhGvznQuA@mail.gmail.com>
 <CALDaNm0DN3TJsSP6PT=maw1KLKvhHwFfOhokUGKprLaiZrU-mw@mail.gmail.com>
Cc: Andres Freund <andres@anarazel.de>,
 PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Organization: EnterpriseDB
Message-ID: <55526d79-247d-83a1-0961-7d42e0db1870@enterprisedb.com>
Date: Fri, 15 Jan 2021 09:53:05 +0100
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:52.0)
 Gecko/20100101 Thunderbird/52.9.1
MIME-Version: 1.0
In-Reply-To: 
 <CALDaNm0DN3TJsSP6PT=maw1KLKvhHwFfOhokUGKprLaiZrU-mw@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
X-Host-Lookup-Failed: Reverse DNS lookup failed for 66.111.4.238 (deferred)
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Precedence: bulk

On 2020-12-08 10:38, vignesh C wrote:
> I have implemented printing of backtrace based on handling it in
> CHECK_FOR_INTERRUPTS. This patch also includes the change to allow
> getting backtrace of any particular process based on the suggestions.
> Attached patch has the implementation for the same.
> Thoughts?

Are we willing to use up a signal for this?