MIME-Version: 1.0
References: <CAAu_hGujUz250rkREPWztG2R1EPSvcTdGfxLAwi5EquUEq64fA@mail.gmail.com>
In-Reply-To: <CAAu_hGujUz250rkREPWztG2R1EPSvcTdGfxLAwi5EquUEq64fA@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Sat, 15 Feb 2025 14:14:43 -0500
Message-ID: <CANzqJaACBCTmxejwZwEHPF-3Uee0eTA73f5hL5Z9PvWZR7we-A@mail.gmail.com>
Subject: Re: Bash profile
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000340f21062e331bd0"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaACBCTmxejwZwEHPF-3Uee0eTA73f5hL5Z9PvWZR7we-A%40mail.gmail.com>
Precedence: bulk

--000000000000340f21062e331bd0
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Sat, Feb 15, 2025 at 2:01=E2=80=AFPM Yongye Serkfem <yserkfem@gmail.com>=
 wrote:

> Hi Everyone!
> I would appreciate any assistance with configuring the bash profile to ru=
n
> two different postgresql versions. Specifically V12.7 and 15.7
>

Create a bash function that exports PGDATA to the relevant directory, based
on the parameter you pass.
Add as much error checking (to ensure that the parameter you passed
actually points to a real data dir and that the postmaster is running.  How
you do that depends on whether it's Debian-based, RH-based or something
else.

We, for example, have standardized on data directories in the format:
/Database/<MajorVer>/data

Thus, something as simple as this would work for us:
pgswitch() { export PGDATA=3D/Database/${1}/data ; }

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

--000000000000340f21062e331bd0
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Sat, Feb 15, 2025 at 2:01=E2=80=AFPM Y=
ongye Serkfem &lt;<a href=3D"mailto:yserkfem@gmail.com">yserkfem@gmail.com<=
/a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container"><block=
quote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1=
px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"auto">Hi Everyone!<=
div dir=3D"auto">I would appreciate any assistance with configuring the bas=
h profile to run two different postgresql versions. Specifically V12.7 and =
15.7</div></div></blockquote><div><br></div><div>Create a bash function tha=
t exports PGDATA to the relevant directory, based on the parameter you pass=
.</div><div>Add as much error checking (to ensure that the parameter you pa=
ssed actually points to a real data dir and that the postmaster is running.=
=C2=A0 How you do that depends on whether it&#39;s Debian-based, RH-based o=
r something else.</div><div><br></div><div>We, for=C2=A0example, have stand=
ardized on data directories in the format:</div><div>/Database/&lt;MajorVer=
&gt;/data</div><div><br></div><div>Thus, something as simple as this would =
work for us:</div><div>pgswitch() { export PGDATA=3D/Database/${1}/data ; }=
</div><div><br></div></div><span class=3D"gmail_signature_prefix">-- </span=
><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Death to &=
lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil me, I&#39;m still ali=
ve.<br><div><div>&lt;Redacted&gt; lobster!</div></div></div></div></div></d=
iv>

--000000000000340f21062e331bd0--