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 <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1u8HJI-0002We-3e
	for pgsql-hackers@arkaria.postgresql.org; Fri, 25 Apr 2025 11:33:36 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1u8HJE-009q9w-SY
	for pgsql-hackers@arkaria.postgresql.org; Fri, 25 Apr 2025 11:33:33 +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 <cb@df7cb.de>)
	id 1u8HJE-009q9o-Ij
	for pgsql-hackers@lists.postgresql.org; Fri, 25 Apr 2025 11:33:33 +0000
Received: from mout-p-101.mailbox.org ([80.241.56.151])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <cb@df7cb.de>)
	id 1u8HJB-001x7t-0h
	for pgsql-hackers@postgresql.org;
	Fri, 25 Apr 2025 11:33:32 +0000
Received: from smtp1.mailbox.org (smtp1.mailbox.org [IPv6:2001:67c:2050:b231:465::1])
	(using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)
	 key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256)
	(No client certificate requested)
	by mout-p-101.mailbox.org (Postfix) with ESMTPS id 4ZkW1d61dDz9t3G;
	Fri, 25 Apr 2025 13:33:25 +0200 (CEST)
Date: Fri, 25 Apr 2025 13:33:22 +0200
From: Christoph Berg <myon@debian.org>
To: "David E. Wheeler" <david@justatheory.com>
Cc: Peter Eisentraut <peter@eisentraut.org>,
	Matheus Alcantara <matheusssilv97@gmail.com>,
	Andrew Dunstan <andrew@dunslane.net>,
	Gabriele Bartolini <gabriele.bartolini@enterprisedb.com>,
	Craig Ringer <craig.ringer@enterprisedb.com>,
	Robert Haas <robertmhaas@gmail.com>,
	Alvaro Herrera <alvherre@alvh.no-ip.org>,
	PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: RFC: Additional Directory for Extensions
Message-ID: <aAtzApxI8A03tiXc@msg.df7cb.de>
Mail-Followup-To: Christoph Berg <myon@debian.org>,
	"David E. Wheeler" <david@justatheory.com>,
	Peter Eisentraut <peter@eisentraut.org>,
	Matheus Alcantara <matheusssilv97@gmail.com>,
	Andrew Dunstan <andrew@dunslane.net>,
	Gabriele Bartolini <gabriele.bartolini@enterprisedb.com>,
	Craig Ringer <craig.ringer@enterprisedb.com>,
	Robert Haas <robertmhaas@gmail.com>,
	Alvaro Herrera <alvherre@alvh.no-ip.org>,
	PostgreSQL-development <pgsql-hackers@postgresql.org>
References: <CAFY6G8dGcv1D8tCkjrz+9DvAYG9h4U=hBm0VXjJEXExy44hauQ@mail.gmail.com>
 <CAFY6G8eOMkGXLqzUz=qXrwt4X_HvmVZ13570DAbgAiw+3q03DA@mail.gmail.com>
 <CAFY6G8fV5FTqn7p8pxbvPYUD5+ffik-J50GChjKH2Gg7d=fRPg@mail.gmail.com>
 <38c53446-6b65-4222-b76b-351e56f4841c@eisentraut.org>
 <CAFY6G8cGeUV0f5K8v-Du0ts3iZyRE6Q5dNtYjQq8cjS4epLX5A@mail.gmail.com>
 <7c178ff3-20a5-493e-a704-e6b3263e782f@eisentraut.org>
 <CAFY6G8d56BK5TZ7K+uw4DHLZ=9Th3p+E1x4pp26nJ_K5k4EUwA@mail.gmail.com>
 <28e98657-9369-4539-9e06-9124d1e77853@eisentraut.org>
 <6B5BF07B-8A21-48E3-858C-1DC22F3A28B4@justatheory.com>
 <25075595-41F1-4BDA-9390-9E0D983BA909@justatheory.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <25075595-41F1-4BDA-9390-9E0D983BA909@justatheory.com>
X-Rspamd-Queue-Id: 4ZkW1d61dDz9t3G
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>
Archived-At: <https://www.postgresql.org/message-id/aAtzApxI8A03tiXc%40msg.df7cb.de>
Precedence: bulk

Re: David E. Wheeler
> +<programlisting>
> +make install prefix=/etc/postgresql

I'd use /usr/local/postgresql there. "/etc" is just wrong.

> +</programlisting>
> +    This will install the control SQL files into
> +    <literal>/etc/postgresql/share</literal> and shared modules into
> +    <literal>/etc/postgresql/lib</literal>. If the prefix does not
> +    include the strings <literal>postgresql</literal> or

Just "postgres", see src/Makefile.global.in:86.

> +    <literal>pgsql</literal>, such as:
> +<programlisting>
> +make install prefix=/etc/extras

/usr/local/extras

> +</programlisting>
> +    Then the <literal>postgresql</literal> directory will be appended io the
> +    prefix, installing the control SQL files into

"the extension control and SQL files"

> +    <literal>/etc/extras/postgresql/share</literal> and shared modules into

.../postgresql/share/extension because ...

> +    <literal>/etc/extras/postgresql/lib</literal>. Either way, you'll need to
> +    set <xref linkend="guc-extension-control-path"/> and <xref
> +    linkend="guc-dynamic-library-path"/> to allow
> +    <productname>PostgreSQL</productname> to find the files:
> +</programlisting>
> +extension_control_path = '/etc/extras/postgresql/share/extension:$system'

... it's used here.

Christoph