Feedback-ID: i76984098:Fastmail
Message-ID: <bd623950-d717-4e6b-b177-bd94ca327549@aklaver.com>
Date: Sat, 15 Feb 2025 13:09:35 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Bash profile
To: Yongye Serkfem <yserkfem@gmail.com>, Ron Johnson <ronljohnsonjr@gmail.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
References: <CAAu_hGujUz250rkREPWztG2R1EPSvcTdGfxLAwi5EquUEq64fA@mail.gmail.com>
 <CANzqJaACBCTmxejwZwEHPF-3Uee0eTA73f5hL5Z9PvWZR7we-A@mail.gmail.com>
 <CAAu_hGsPXp3Yn+WdZHLT+t3MXHgHSp+FSUqcu5G=O7oRrm9+GQ@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAAu_hGsPXp3Yn+WdZHLT+t3MXHgHSp+FSUqcu5G=O7oRrm9+GQ@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/bd623950-d717-4e6b-b177-bd94ca327549%40aklaver.com>
Precedence: bulk

On 2/15/25 11:17, Yongye Serkfem wrote:
> I am upgrading from version 12.7 to 15.7

You are going to have to explain what, in your situation, BASH has to do 
with the upgrade process. Generally migrations depend on Postgres 
programs and are not shell specific.

> 
> 
> On Sat, Feb 15, 2025, 2:15 PM Ron Johnson <ronljohnsonjr@gmail.com 
> <mailto:ronljohnsonjr@gmail.com>> wrote:
> 
>     On Sat, Feb 15, 2025 at 2:01 PM Yongye Serkfem <yserkfem@gmail.com
>     <mailto: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!
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com