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 1u8Oec-00335L-V6 for pgsql-hackers@arkaria.postgresql.org; Fri, 25 Apr 2025 19:24:07 +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 1u8Oeb-00Ef2Z-0M for pgsql-hackers@arkaria.postgresql.org; Fri, 25 Apr 2025 19:24:05 +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 1u8Oea-00Ef2P-LG for pgsql-hackers@lists.postgresql.org; Fri, 25 Apr 2025 19:24:05 +0000 Received: from fhigh-a8-smtp.messagingengine.com ([103.168.172.159]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u8OeX-0023ZC-22 for pgsql-hackers@postgresql.org; Fri, 25 Apr 2025 19:24:04 +0000 Received: from phl-compute-07.internal (phl-compute-07.phl.internal [10.202.2.47]) by mailfhigh.phl.internal (Postfix) with ESMTP id 0FD3B1140324; Fri, 25 Apr 2025 15:24:00 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-07.internal (MEProxy); Fri, 25 Apr 2025 15:24:00 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=justatheory.com; 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=fm2; t=1745609040; x= 1745695440; bh=ddz/5rgpUfM6QKsDMl3WElH1ZCsm3MhqCUgJISSmfR8=; b=u uf3P9D36NKxfJzuIcRnNli0H3kaDyaSbg8SS61u06+EzneSnDJBkHZVt5Ldpv5zg uvO//mDqlHSgSNBezI2O3jW9IpVexV8fnzGfOsimuEg01j3VWoVnA5Q4TLen0mC6 Lf66kvCBZ0JFOYZGq8pNw6Ai/wOniKaGsBCt4xeDBZUwF7t96roma32/pMhchPl3 81LVWLGiICZEU513GgfOIF3z+GhRAaXr39SEOwWnHgC/BTOPFUhQwOotEwnCghj1 Xqtl/O+tCh+OglT522hqU2TSbTAElaH8XHrjAylhR20+/FXdNCqzzgQcYH1EhQHr kCp9djdk3ce1JbxBwEJdQ== 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=fm3; t= 1745609040; x=1745695440; bh=ddz/5rgpUfM6QKsDMl3WElH1ZCsm3MhqCUg JISSmfR8=; b=noer7T3gryx8LaTeDODC3Pr5yLMf55U2fKtRz6LdLKyTKK++OA6 EalOAT4jZeBGYbXp6l9Yz+jN+Sk/QZ+mo1PzJJiXQ55Lb+j68KoiVZA15s10vU+C 8gvVU0PEk/IKzgu4gRCqT6eq2Jdp+MDESPCyyQoCFnBPjPfohQ73nr5ggGVr+s0/ zi7iLWTLwjfIu9mi1ed+J1q8xilXFe9zf3baUfIyT4hLhRk50AU3YcaRKN4bc3Aa B6XhwaimJnHEhC59elgpocIBgC6Gb5oIfImZNEaeZ8UZ8iu13ewKQYcRHk3W/D5r nlHpg/Lx76QcHWYKxTiWaKzhgdp96VcsCdA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgddvheefudejucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggv pdfurfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpih gvnhhtshculddquddttddmnecujfgurhephffktgggufffjgevvfhfofesghdtmherhhdt jeenucfhrhhomhepfdffrghvihguucfgrdcuhghhvggvlhgvrhdfuceouggrvhhiugesjh hushhtrghthhgvohhrhidrtghomheqnecuggftrfgrthhtvghrnhephedvieejueevffdv keffteelheelledtgfffvefgkedtuedvudeuleeltdfggeevnecuffhomhgrihhnpehgih hthhhusgdrtghomhenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhl fhhrohhmpegurghvihgusehjuhhsthgrthhhvghorhihrdgtohhmpdhnsggprhgtphhtth hopeelpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopehmhihonhesuggvsghirghn rdhorhhgpdhrtghpthhtohepphgvthgvrhesvghishgvnhhtrhgruhhtrdhorhhgpdhrtg hpthhtohepmhgrthhhvghushhsshhilhhvleejsehgmhgrihhlrdgtohhmpdhrtghpthht oheprghnughrvgifseguuhhnshhlrghnvgdrnhgvthdprhgtphhtthhopehgrggsrhhivg hlvgdrsggrrhhtohhlihhnihesvghnthgvrhhprhhishgvuggsrdgtohhmpdhrtghpthht oheptghrrghighdrrhhinhhgvghrsegvnhhtvghrphhrihhsvggusgdrtghomhdprhgtph htthhopehrohgsvghrthhmhhgrrghssehgmhgrihhlrdgtohhmpdhrtghpthhtoheprghl vhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrghdprhgtphhtthhopehpghhsqhhlqd hhrggtkhgvrhhssehpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i7c334307:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 25 Apr 2025 15:23:58 -0400 (EDT) From: "David E. Wheeler" Message-Id: Content-Type: multipart/signed; boundary="Apple-Mail=_4A68AE1F-9E12-48EA-AD6D-42DDBFE52131"; protocol="application/pgp-signature"; micalg=pgp-sha256 Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.500.181.1.5\)) Subject: Re: RFC: Additional Directory for Extensions Date: Fri, 25 Apr 2025 15:23:47 -0400 In-Reply-To: Cc: Peter Eisentraut , Matheus Alcantara , Andrew Dunstan , Gabriele Bartolini , Craig Ringer , Robert Haas , Alvaro Herrera , PostgreSQL-development To: Christoph Berg References: <38c53446-6b65-4222-b76b-351e56f4841c@eisentraut.org> <7c178ff3-20a5-493e-a704-e6b3263e782f@eisentraut.org> <28e98657-9369-4539-9e06-9124d1e77853@eisentraut.org> <6B5BF07B-8A21-48E3-858C-1DC22F3A28B4@justatheory.com> <25075595-41F1-4BDA-9390-9E0D983BA909@justatheory.com> X-Mailer: Apple Mail (2.3826.500.181.1.5) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail=_4A68AE1F-9E12-48EA-AD6D-42DDBFE52131 Content-Type: multipart/mixed; boundary="Apple-Mail=_7A6F95EE-8EC4-46E5-B400-C159B73BDA04" --Apple-Mail=_7A6F95EE-8EC4-46E5-B400-C159B73BDA04 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 On Apr 25, 2025, at 07:33, Christoph Berg wrote: >=20 > Re: David E. Wheeler >> + >> +make install prefix=3D/etc/postgresql >=20 > I'd use /usr/local/postgresql there. "/etc" is just wrong. Thank you for the review. Here=E2=80=99s v3*. Best, David * Also reviewable as a GitHub PR[1]. [1]: https://github.com/theory/postgres/pull/10 --Apple-Mail=_7A6F95EE-8EC4-46E5-B400-C159B73BDA04 Content-Disposition: attachment; filename=v3-0001-Flesh-out-docs-for-the-prefix-make-variable.patch Content-Type: application/octet-stream; name=v3-0001-Flesh-out-docs-for-the-prefix-make-variable.patch; x-unix-mode=0644 Content-Transfer-Encoding: quoted-printable =46rom=20d49d3445ca5bdde436713dc8a2ae7707683851e3=20Mon=20Sep=2017=20= 00:00:00=202001=0AFrom:=20"David=20E.=20Wheeler"=20= =0ADate:=20Fri,=2025=20Apr=202025=2015:22:23=20= -0400=0ASubject:=20[PATCH=20v3]=20Flesh=20out=20docs=20for=20the=20= `prefix`=20make=20variable=0A=0AThe=20variable=20is=20a=20bit=20magical=20= in=20how=20it=20requires=20"postgresql"=20or=20"pgsql"=0Ato=20be=20part=20= of=20the=20path,=20and=20files=20end=20up=20in=20its=20`share`=20and=20= `lib`=0Asubdirectories.=20So=20mention=20all=20that=20and=20show=20an=20= example=20of=20setting=0A`extension_control_path`=20and=20= `dynamic_library_path`=20to=20use=20those=0Alocations.=0A---=0A=20= doc/src/sgml/extend.sgml=20|=2033=20+++++++++++++++++++++++++++++----=0A=20= 1=20file=20changed,=2029=20insertions(+),=204=20deletions(-)=0A=0Adiff=20= --git=20a/doc/src/sgml/extend.sgml=20b/doc/src/sgml/extend.sgml=0Aindex=20= 64f8e133cae..05063d4e7bc=20100644=0A---=20a/doc/src/sgml/extend.sgml=0A= +++=20b/doc/src/sgml/extend.sgml=0A@@=20-1809,10=20+1809,35=20@@=20= include=20$(PGXS)=0A=20=20=20=20=20setting=20= PG_CONFIG=20to=20point=20to=20its=0A=20=20=20=20=20= pg_config=20program,=20either=20within=20the=20= makefile=0A=20=20=20=20=20or=20on=20the=20make=20= command=20line.=0A-=20=20=20=20You=20can=20also=20select=20a=20separate=20= installation=20directory=20for=20your=20extension=0A-=20=20=20=20by=20= setting=20the=20make=20variable=20= prefix=0A-=20=20=20=20on=20the=20= make=20command=20line.=20=20(But=20this=20will=20then=20= require=0A-=20=20=20=20additional=20setup=20to=20get=20the=20server=20to=20= find=20the=20extension=20there.)=0A+=20=20=20=0A+=0A+=20=20=20= =0A+=20=20=20=20You=20can=20also=20select=20a=20separate=20= directory=20prefix=20in=20which=20to=20install=20your=0A+=20=20=20=20= extension's=20files=20by=20setting=20the=20make=20= variable=0A+=20=20=20=20prefix=20when=20executing=20= make=20install=0A+=20=20=20=20like=20so:=0A= +=0A+make=20install=20prefix=3D/usr/local/postgresql=0A= +=0A+=20=20=20=20This=20will=20install=20the=20control=20= SQL=20files=20into=0A+=20=20=20=20= /usr/local/postgresql/share=20and=20shared=20modules=20= into=0A+=20=20=20=20/usr/local/postgresql/lib.=20If=20= the=20prefix=20does=20not=0A+=20=20=20=20include=20the=20strings=20= postgres=20or=0A+=20=20=20=20= pgsql,=20such=20as:=0A+=0A+make=20= install=20prefix=3D/usr/local/extras=0A+=0A+=20=20=20=20= Then=20the=20postgresql=20directory=20will=20be=20= appended=20io=20the=0A+=20=20=20=20prefix,=20installing=20the=20control=20= and=20SQL=20files=20into=0A+=20=20=20=20= /usr/local/extras/postgresql/share/extension=20and=20= shared=0A+=20=20=20=20modules=20into=20= /usr/local/extras/postgresql/lib.=20Either=0A+=20=20=20= =20way,=20you'll=20need=20to=20set=20=20and=0A+=20=20=20=20=20to=20allow=0A+=20=20=20=20= PostgreSQL=20to=20find=20the=20files:=0A= +=0A+extension_control_path=20=3D=20= '/usr/local/extras/postgresql/share/extension:$system'=0A= +dynamic_library_path=20=3D=20'/usr/local/extras/postgresql/lib:$libdir'=0A= +=20=0A=20=20=20=20=0A=20=0A=20=20=20=20=0A= --=20=0A2.48.1=0A=0A= --Apple-Mail=_7A6F95EE-8EC4-46E5-B400-C159B73BDA04 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii --Apple-Mail=_7A6F95EE-8EC4-46E5-B400-C159B73BDA04-- --Apple-Mail=_4A68AE1F-9E12-48EA-AD6D-42DDBFE52131 Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename=signature.asc Content-Type: application/pgp-signature; name=signature.asc Content-Description: Message signed with OpenPGP -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEEd+KfmbOQis6ZycGGkt9idPjIgfEFAmgL4UQACgkQkt9idPjI gfG7yRAAhrMfKCOM8Am6lPKeGjK/sd1/Uv9Oq+ccgGgtQBqQHX6SUmFVHcMCdyf1 b7iI6LgtqWHNOUkA61w+6s7QXocQI2TpY4w4/0pvwO40g+0Fj26F1PrTeUZ8817t VAVGE/uoT4b4daRx3p8Tr+61+ygj6rDbEWXUS5W1VNY7qVfjRP5w6Ia+co+CxjxX Pb908TBgL13a/o23KRFsBLECqY6P5cktma6rnStbUGqOzlOops0dz2zNGPUdUeeE 1C2G+QrsgR997jN0oO2bXVWNbZoVx+yXEGJspEZKslyI1+WlRWDXLSg1ZkPcD0y3 pHi+YjhS7FvZNw69M6J2WG1zM6ij+w9pwpHOck2nczfrIB4V7GxlBqRb4YJdfmoF UIbUkaBvPzyyv+KmRsnWyAuY0qdJ+SSO3IVHLQx45wwdbV7xfu0bndbZlJJSI2kO Q2fagKG1JvnWqh/iE3DG0w/oqSQEtB2QaKixpN3aq7T28e1TDgiL8Oado5m3gMmg Gdxo5zVYbdNoEilPL6hNrbeaByJ8EbecRcVp/pwM23TU8Lkr9oB2IPuo/aaxdoyj kaOci0wirX/w6VmeXb0zEj7JmJl0/WUxiJA8ULS9EWDh5ENiqK30IZSSp6URjNkp Nj5+3XaBqENJz8E+lIZUlDSXTmovS+eY1BpDl6fOxdEGRSDjL9I= =6BOv -----END PGP SIGNATURE----- --Apple-Mail=_4A68AE1F-9E12-48EA-AD6D-42DDBFE52131--