Date: Thu, 25 May 2017 22:06:07 +0200 From: Baptiste Daroussin <bapt@FreeBSD.org> To: =?iso-8859-1?Q?Jos=E9_Garc=EDa?= Juanino <jjuanino@gmail.com> Cc: ports <freebsd-ports@freebsd.org> Subject: Re: Several PostgreSQL versions installed Message-ID: <20170525200607.3onokw5yqrprpwdr@ivaldir.net> In-Reply-To: <CAAVO5%2BJ_C597=-ueJoEaqW4xYXD1UOyz_z2CSARjS8Lfoe9oVw@mail.gmail.com> References: <CAAVO5%2BJ_C597=-ueJoEaqW4xYXD1UOyz_z2CSARjS8Lfoe9oVw@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
--3mqpi5xnkc246zgm Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, May 25, 2017 at 09:59:08PM +0200, Jos=E9 Garc=EDa Juanino wrote: > Hi FreeBSD porters, >=20 >=20 > I have been read the following thread >=20 > "Proposal to fix postgresql package maintainance nightmare" >=20 > https://lists.freebsd.org/pipermail/freebsd-ports/2015-July/099842.html >=20 > but I think that, two years later, there is no progress on this matter. > I am unaware if there is any project that addresses this issue, so my > apologies if this work is already in progress. No progress as far as I am aware. except a PoC (early, ugly, unfinished) https://people.freebsd.org/~bapt/pgsql95.diff >=20 > The goal of the new postgresql port schema should be, in my honest > opinion: >=20 > * It must allow to install distinct version without ugly hacks as jails, > etc. Jails are a overkill to accomplish this task. >=20 > * Each software version must live in a separate directory > ${LOCALBASE}/pgsql/X.Y: >=20 > /usr/local/pgsql/9.2 > /usr/local/pgsql/9.4 > /usr/local/pgsql/9.6 >=20 > and so on. Yes this is what I was proposing >=20 >=20 > * It is not necessary to provide an installed version as the default. > For example, if we need 9.5 and 9.6 versions installed, both are > equally valid, and we do not need the standard postgresql binaries > (pg_dump, psql, pg_ctl, etc) installed in the standard PATH as > /bin:/usr/bin:/usr/local/bin. Those binaries are located under > /usr/local/pgsql/X.Y/bin directory, and everyone can configure the > shell environment variable PATH to add the previous directory: > PATH=3D$PATH:/usr/local/pgsql/X.Y/bin. Please do not make symlinks from > /usr/local/bin/pg_some to specific /usr/local/pgsql/X.Y/bin/pg_some, > it has very little advantages and a lot of drawbacks. Under a prompt > command line, a skilled database administrator always need to know > what command version is executing and do not need an standard location > as /usr/local/bin. For a database administrator yes playing with the path is enough, but for a= new comer installing pgsql for his blog this would be complicated >=20 >=20 > * The rc and the periodic script must be versioned also: >=20 > /usr/local/etc/rc.d/postgresql9.6 > /usr/local/etc/rc.d/postgresql5.6 >=20 yes One important thing is there is a need for a small modification for the postgresql build system: add a proper RUNPATH for the binaries to always fi= nd the right libpq >=20 >=20 > Best regards, and thanks to the volunteers for make FreeBSD an great > operating system! >=20 Note that the same should apply to mysql/mariadb/etc bapt --3mqpi5xnkc246zgm Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCAAdFiEEgOTj3suS2urGXVU3Y4mL3PG3PloFAlknORUACgkQY4mL3PG3 PlqeCQ//bAQhQA2UZocucdphCBnW/yJyzTM1Gld4tp8430ygIdtKOMJR31T1ik+P 2+Y/ccaaeaxQQFrHvrW+9+nBtYC8yeCq4iwYzbSfdzCynFfhTp8HLkl49pTo/cUn 2etKVjJoOz6eg+A/HhDBsbM4/OvvPvfoy1konSe7hk5oNFZ+mrp7ZXibhSt5w4Ys jcBC92UUR9qWJf51Z2yFt1gygVOjNev8rCNL82L6FHS5sZG9JfKtC2lKqDpidZyf qjTDv6Pj7KOUsREVZcc13Es/FWVPZHO/95y4nnw7VZ5HrtLG0ypzfXoJODkGlIA/ M0U3IYZUDsSWNBV8dnLZpXFghER0hnRlu6RgkL+ScI7DlwIY/o3VeWEpb7jP5f0i VbpkRrAkAzm4ArZt8U09z/8xaqOQDK7no/Pp2bK8ovfS4l/OwWMVMUqtVRGjqAtW 5lzjssGq2olWK/nuq9Ii75O/I7CK8Z65iVEpOs0kFn8/ja8MgiK6jCUtWjn1YWRQ cn2weqIu/ar8a02JwztjxdQpav/lTs1syES1kICjy5mnEwljjzjOZgosojBldUkr IFqiCuzMboYs0aFJQdD18JF3fjJsx4WYpyp0uOCxEhTuzFYVgYPnezQ/47YlmBxl 2/gojd6eHZL+U9vqYbACBbh4nhNX6NzBlfVmTuRSfIxEETVqXdk= =1TE4 -----END PGP SIGNATURE----- --3mqpi5xnkc246zgm--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20170525200607.3onokw5yqrprpwdr>