Re: Bash profile - Mailing list pgsql-general

From Ron Johnson
Subject Re: Bash profile
Date
Msg-id CANzqJaACBCTmxejwZwEHPF-3Uee0eTA73f5hL5Z9PvWZR7we-A@mail.gmail.com
Whole thread Raw
In response to Bash profile  (Yongye Serkfem <yserkfem@gmail.com>)
Responses Re: Bash profile
List pgsql-general
On Sat, Feb 15, 2025 at 2:01 PM Yongye Serkfem <yserkfem@gmail.com> 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=/Database/${1}/data ; }

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

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Bash profile
Next
From: Yongye Serkfem
Date:
Subject: Re: Bash profile