MIME-Version: 1.0
References: <CAAu_hGujUz250rkREPWztG2R1EPSvcTdGfxLAwi5EquUEq64fA@mail.gmail.com>
 <CANzqJaACBCTmxejwZwEHPF-3Uee0eTA73f5hL5Z9PvWZR7we-A@mail.gmail.com>
In-Reply-To: <CANzqJaACBCTmxejwZwEHPF-3Uee0eTA73f5hL5Z9PvWZR7we-A@mail.gmail.com>
From: Yongye Serkfem <yserkfem@gmail.com>
Date: Sat, 15 Feb 2025 14:17:00 -0500
Message-ID: <CAAu_hGsPXp3Yn+WdZHLT+t3MXHgHSp+FSUqcu5G=O7oRrm9+GQ@mail.gmail.com>
Subject: Re: Bash profile
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000005b83c5062e3323f1"
Archived-At: <https://www.postgresql.org/message-id/CAAu_hGsPXp3Yn%2BWdZHLT%2Bt3MXHgHSp%2BFSUqcu5G%3DO7oRrm9%2BGQ%40mail.gmail.com>
Precedence: bulk

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

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.co=
m> 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.  H=
ow
> 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!
>

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

<p dir=3D"ltr">I am upgrading from version 12.7 to 15.7</p>
<br><div class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=
=3D"gmail_attr">On Sat, Feb 15, 2025, 2:15 PM Ron Johnson &lt;<a href=3D"ma=
ilto:ronljohnsonjr@gmail.com">ronljohnsonjr@gmail.com</a>&gt; wrote:<br></d=
iv><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left=
:1px #ccc solid;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:yserk=
fem@gmail.com" target=3D"_blank" rel=3D"noreferrer">yserkfem@gmail.com</a>&=
gt; wrote:</div><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote=
" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);=
padding-left:1ex"><div dir=3D"auto">Hi Everyone!<div dir=3D"auto">I would a=
ppreciate any assistance with configuring the bash profile to run two diffe=
rent postgresql versions. Specifically V12.7 and 15.7</div></div></blockquo=
te><div><br></div><div>Create a bash function that exports PGDATA to the re=
levant directory, based on the parameter you pass.</div><div>Add as much er=
ror checking (to ensure that the parameter you passed actually points to a =
real data dir and that the postmaster is running.=C2=A0 How you do that dep=
ends on whether it&#39;s Debian-based, RH-based or something else.</div><di=
v><br></div><div>We, for=C2=A0example, have standardized on data directorie=
s 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>pgs=
witch() { export PGDATA=3D/Database/${1}/data ; }</div><div><br></div></div=
><span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" clas=
s=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butte=
r sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Redac=
ted&gt; lobster!</div></div></div></div></div></div>
</blockquote></div>

--0000000000005b83c5062e3323f1--