MIME-Version: 1.0
References: <CAAu_hGujUz250rkREPWztG2R1EPSvcTdGfxLAwi5EquUEq64fA@mail.gmail.com>
 <CANzqJaACBCTmxejwZwEHPF-3Uee0eTA73f5hL5Z9PvWZR7we-A@mail.gmail.com> <CAAu_hGsPXp3Yn+WdZHLT+t3MXHgHSp+FSUqcu5G=O7oRrm9+GQ@mail.gmail.com>
In-Reply-To: <CAAu_hGsPXp3Yn+WdZHLT+t3MXHgHSp+FSUqcu5G=O7oRrm9+GQ@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Sat, 15 Feb 2025 16:02:56 -0500
Message-ID: <CANzqJaA9oo=LzRPTK76E9fpCOssfx_0Lbwd7qNyWgUs_DVM4ZA@mail.gmail.com>
Subject: Re: Bash profile
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000336da2062e349e54"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaA9oo%3DLzRPTK76E9fpCOssfx_0Lbwd7qNyWgUs_DVM4ZA%40mail.gmail.com>
Precedence: bulk

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

So?

Honestly, your question has zero to do with Postgresql.  Its basic Linux
configuration.

Before the migration, PGDATA and PATH should point to the v12 "stuff", and
after the migration they should point to the v15 "stuff".  It's that simple=
.

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

> I am upgrading from version 12.7 to 15.7
>
> On Sat, Feb 15, 2025, 2:15 PM Ron Johnson <ronljohnsonjr@gmail.com> wrote=
:
>
>> On Sat, Feb 15, 2025 at 2:01=E2=80=AFPM Yongye Serkfem <yserkfem@gmail.c=
om>
>> wrote:
>>
>>> Hi Everyone!
>>> I would appreciate any assistance with configuring the bash profile to
>>> run 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 ; }
>>
>> --
>> Death to <Redacted>, and butter sauce.
>> Don't boil me, I'm still alive.
>> <Redacted> lobster!
>>
>

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

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

<div dir=3D"ltr"><div>So?</div><div><br></div><div>Honestly, your question =
has zero to do with Postgresql.=C2=A0 Its basic Linux configuration.</div><=
div><br></div><div>Before the migration, PGDATA and PATH should point to th=
e v12 &quot;stuff&quot;, and after the migration they should point to the v=
15 &quot;stuff&quot;.=C2=A0 It&#39;s that simple.</div><br><div class=3D"gm=
ail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On S=
at, Feb 15, 2025 at 2:17=E2=80=AFPM Yongye Serkfem &lt;<a href=3D"mailto:ys=
erkfem@gmail.com">yserkfem@gmail.com</a>&gt; wrote:<br></div><blockquote cl=
ass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid=
 rgb(204,204,204);padding-left:1ex"><p dir=3D"ltr">I am upgrading from vers=
ion 12.7 to 15.7</p>
<br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Sat=
, Feb 15, 2025, 2:15 PM Ron Johnson &lt;<a href=3D"mailto:ronljohnsonjr@gma=
il.com" target=3D"_blank">ronljohnsonjr@gmail.com</a>&gt; wrote:<br></div><=
blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-l=
eft:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=
=3D"ltr">On Sat, Feb 15, 2025 at 2:01=E2=80=AFPM Yongye Serkfem &lt;<a href=
=3D"mailto:yserkfem@gmail.com" rel=3D"noreferrer" target=3D"_blank">yserkfe=
m@gmail.com</a>&gt; wrote:</div><div class=3D"gmail_quote"><blockquote clas=
s=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid r=
gb(204,204,204);padding-left:1ex"><div dir=3D"auto">Hi Everyone!<div dir=3D=
"auto">I would appreciate any assistance with configuring the bash profile =
to run two different postgresql versions. Specifically V12.7 and 15.7</div>=
</div></blockquote><div><br></div><div>Create a bash function that exports =
PGDATA to the relevant directory, based on the parameter you pass.</div><di=
v>Add as much error checking (to ensure that the parameter you passed actua=
lly 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 or somethin=
g else.</div><div><br></div><div>We, for=C2=A0example, have standardized 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 u=
s:</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;Redacte=
d&gt;, and butter sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br><di=
v><div>&lt;Redacted&gt; lobster!</div></div></div></div></div></div>
</blockquote></div>
</blockquote></div><div><br clear=3D"all"></div><div><br></div><span class=
=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_s=
ignature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div=
>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobs=
ter!</div></div></div></div></div></div>

--000000000000336da2062e349e54--