From: Tom Lane <tgl@sss.pgh.pa.us>
To: AJ ONeal <coolaj86@proton.me>
cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Re: How to Build Postgres in a Portable / Relocatable fashion?
In-reply-to: <rjf-sGbM2HPV0EZuoN9yA4GDL9CqVCD2AzkwyByjKmF5mGstw6TrqT_5OIC1yPvfSAsjyE30Y4i4Oojq5nwQXtjdFVF7dx0cXxJgSBARBV8=@proton.me>
References: <v_-p47epUmnjcXPhpH9dygB6PKkwhLsccfj7o0snGd-GNubV138HZaU1YvAcyoqeQ4pqcT20hgHbmVlwaYXpcWDZ_iDCREz1A8hkkEDYdF8=@proton.me> <f07765c7-b42b-4339-8044-c7b10d81b436@aklaver.com> <rjf-sGbM2HPV0EZuoN9yA4GDL9CqVCD2AzkwyByjKmF5mGstw6TrqT_5OIC1yPvfSAsjyE30Y4i4Oojq5nwQXtjdFVF7dx0cXxJgSBARBV8=@proton.me>
Comments: In-reply-to AJ ONeal <coolaj86@proton.me>
	message dated "Fri, 03 May 2024 23:27:12 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <2770929.1714779894.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Fri, 03 May 2024 19:44:54 -0400
Message-ID: <2770930.1714779894@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/2770930.1714779894%40sss.pgh.pa.us>
Precedence: bulk

AJ ONeal <coolaj86@proton.me> writes:
> What I want to create (and provide) is a portable tarball that has
> most of all what it needs in the tarball and will look for relevant
> libraries relative to itself.

See

https://www.postgresql.org/docs/current/installation.html

particularly the discussion of installation relocatability under

https://www.postgresql.org/docs/current/install-make.html#CONFIGURE-OPTION=
S-LOCATIONS

In short, you have to specify an installation path, but as long
as you don't muck with the relative locations of the subdirectories
it should be possible to move the whole tree to a different
installation location.

> Something that Just Works=E2=84=A2 *almost* anywhere (Ubuntu, Debian, Re=
dHat, Suse... maybe even Alpine).

That's a little harder, mainly because the shared libraries for
dependencies like openssl etc may not be 100% compatible across
all those platforms.  Different versions, different build options,
yadda yadda.

Maybe you should be thinking in terms of a docker container
or the like?

			regards, tom lane