Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tLZoy-00Femo-TM for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Dec 2024 03:25:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tLZov-0067LZ-TZ for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Dec 2024 03:24:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tLZou-0067Jx-SA for pgsql-hackers@lists.postgresql.org; Thu, 12 Dec 2024 03:24:58 +0000 Received: from fout-a6-smtp.messagingengine.com ([103.168.172.149]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tLZor-002OFT-UC for pgsql-hackers@postgresql.org; Thu, 12 Dec 2024 03:24:57 +0000 Received: from phl-compute-11.internal (phl-compute-11.phl.internal [10.202.2.51]) by mailfout.phl.internal (Postfix) with ESMTP id 731541383D36; Wed, 11 Dec 2024 22:24:52 -0500 (EST) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-11.internal (MEProxy); Wed, 11 Dec 2024 22:24:52 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm1; t=1733973892; x=1734060292; bh=aQE45tIqAl LIuuXDTHTQmtM1bue6kY/LfG0HV43tYSQ=; b=hMZ+wPp/lVRtU+dwBFHWsUg+F1 +9Pw4jG4Y6zNqfQ7ZFWjggKdHkagEziN2u0fXWfPjSkles/dFAdcoTkwWY8DK6jO BEcetlJXD41MYQKy/HvQ8ECkTBc6aAC5FvYTpIE+bAj0cgfX+boXORnECQK1NArv quz96Md4LzkDXaP1z60DfWhoAmGYGlbGIAtIE/lPuf0fl81/ft1hF1zgIDMz+PWx /alIg3r5Sn9s9DBvjokfLSW7QIgzwP4XgY8zD3YAfjl+wLCE9tDKKPWhDV+YgeN3 fvj1veQ+Q9RzFqXWHDwO7lvAUD+YTaIYTg/WarVr402Ya/K/sBRb8tmAN3KQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t= 1733973892; x=1734060292; bh=aQE45tIqAlLIuuXDTHTQmtM1bue6kY/LfG0 HV43tYSQ=; b=4iCFWcLuuCrT5iTZ2jlpWbwMjeXwFkl+7cg7aFv8zKPXqeywvsd FhFIROtmxD/zClqNPBaW9FZCxvRpDISCQcAEainNJeZpau7UFSm2EnKDgForIiOh vjkj//wGMv7LRwVb+ynb3CCwYnPyT7cs01HeuuOHNv6e0HXUnHWpWP3bHPjfn9+/ 2wrOkZreOhgvzwx5lXWXEBXgIVYhnKpkFYiADyy06+g8utsJdoQo/FvVpivLPKgG UxF7/vuYUYryAOgv5f79reGB26FWgf64TCEAXmD56aw5EwbARQLXr0JxrGdDlHN8 9kikQeMLcdc5rzwbU5F/GZy+knxgZcDT6Zg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefuddrkeefgddtvdcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdpuffr tefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnth hsucdlqddutddtmdenfghrlhcuvffnffculdejtddmnecujfgurhepfffhvfevuffkfhgg tggujgesghdtreertddtvdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoe hmihgthhgrvghlsehprghquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpeetleei fedufffhhfdtteelgeeggeffhfekueevteeigfduudevudetgfegiedvjeenucevlhhush htvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehp rghquhhivghrrdighiiipdhnsggprhgtphhtthhopeehpdhmohguvgepshhmthhpohhuth dprhgtphhtthhopehtghhlsehsshhsrdhpghhhrdhprgdruhhspdhrtghpthhtohepvghu lhgvrhesvghulhgvrhhtohdrtghomhdprhgtphhtthhopegrnhgurhgvshesrghnrghrrg iivghlrdguvgdprhgtphhtthhopehlvghpihhhohhvsehgmhgrihhlrdgtohhmpdhrtghp thhtohepphhgshhqlhdqhhgrtghkvghrshesphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 11 Dec 2024 22:24:50 -0500 (EST) Date: Thu, 12 Dec 2024 12:24:39 +0900 From: Michael Paquier To: Tom Lane Cc: Euler Taveira , Andres Freund , Andrei Lepikhov , pgsql-hackers Subject: Re: Add Postgres module info Message-ID: References: <506788.1733941263@sss.pgh.pa.us> <2qdclwljzvw5abfvo4porr3ehox32icrbtfjaum327ruxts6qm@udexcbweewpq> <556165.1733967268@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="2vuQn12f0R7y9vgU" Content-Disposition: inline In-Reply-To: <556165.1733967268@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --2vuQn12f0R7y9vgU Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Dec 11, 2024 at 08:34:28PM -0500, Tom Lane wrote: > "Euler Taveira" writes: >> +1 for the general idea. I received some reports like [1] related to wal= 2json >> that people wants to obtain the output plugin version. Since it is not i= nstalled >> via CREATE EXTENSION, it is not possible to detect what version is insta= lled, >> hence, some tools cannot have some logic to probe the module version. In= a >> managed environment, it is hard to figure out the exact version for >> non-CREATE-EXTENSION modules, unless it is explicitly informed by the ve= ndor. >=20 > What would you foresee as the SQL API for inspecting a module that's > not tied to an extension? Rather than a function that can be called with a specific module name in input, invent a new system SRF function that would report back for a process all the libraries that have been loaded in it? Presumably, the extra tracking can be done in dfmgr.c with more fields added to DynamicFileList to track the information involved. Being able to print the information of DynamicFileList can be argued as useful on its own as long as its execution can be granted, with superuser right by default. -- Michael --2vuQn12f0R7y9vgU Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmdaV3cACgkQnvQgOdby QH2nAA/8DJPY2MEOiAKWj94V5gbDtC2gFajgZpzFPld9ZEw2G+yBJv2E6hYrivou /VUqcvIUlmvg7W5gyPPsjOuU0mQD251Lpz5Ksmo/rw5sPjF7xvEJ+ZB5lTSSC1n7 MBofH64/OwRgbXenih5rvGs6tlAIIBsbsR7apLq5OvlggYki2vwnU394bM3PQxXX AFp9h1oNEq/5u5qLkTAP8i4u7noszAEm4OwUopPtsGhILPrX7JWHpGA3wmnuxnG7 FymvR62WmgLcx7Yr/7FfXHIKPKZfi2tr78A+fjOkrSQEkEYhYSdufDXms6qUA1Z9 CJ9PEv+bNByg0tF9OAAvfnTM1ExzswjJavJOi2xGbsNoQJLgcw3UpR7kvAIVHCZe 6xriVSGhhMor2qh9aejYgaF2Ndb2pAWekuQyriWzUSEVCZt51y0PBn4s5RYgkjKl xykHVUylgsmTEuginCcrYoZXoYiy9t/C+T2vpxWJbqNkXDCIbTyGuht5S8Y0JD9C ajLACTvL6jiZ30M4xaxGEDtQ3N/qXKphGdj7yMt/H8EsvgP1NvHyUbEwtLKFfiV+ NnND93UTyGyi57xvl23kVvOl7Ma5uh/LiDR6J8kAro0DVsGuGiO+Y+m8GF6suVg+ IwKvKCn20MnlmxJPTnGqZgzAwepzO4BXHSWN7ndQECYEMoNXAeI= =DmSV -----END PGP SIGNATURE----- --2vuQn12f0R7y9vgU--