Re: Bash profile

[Yongye Serkfem]

I am upgrading from version 12.7 to 15.7

On Sat, Feb 15, 2025, 2:15 PM Ron Johnson  wrote:

> On Sat, Feb 15, 2025 at 2:01 PM Yongye Serkfem  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//data
>
> Thus, something as simple as this would work for us:
> pgswitch() { export PGDATA=/Database/${1}/data ; }
>
> --
> Death to , and butter sauce.
> Don't boil me, I'm still alive.
>  lobster!
>

Re: Bash profile

[Ron Johnson]

On Sat, Feb 15, 2025 at 2:01 PM Yongye Serkfem  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//data

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

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

Re: Bash profile

[David G. Johnston]

On Sat, Feb 15, 2025 at 12:01 PM Yongye Serkfem  wrote:

>
> I would appreciate any assistance with configuring the bash profile to run
> two different postgresql versions. Specifically V12.7 and 15.7
>
>
Can you provide more detail on what you are trying to do, and why?  Your
request doesn't make sense as stated.

David J.

Re: Bash profile

[Adrian Klaver]

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 > wrote:


On Sat, Feb 15, 2025 at 2:01 PM Yongye Serkfem mailto:yserk...@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//data

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

-- 
Death to , and butter sauce.

Don't boil me, I'm still alive.
 lobster!



--
Adrian Klaver
adrian.kla...@aklaver.com

Bash profile

[Yongye Serkfem]

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

My regards to all
Yongye Serkfem.

Re: Bash profile

[Ron Johnson]

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 PM Yongye Serkfem  wrote:

> I am upgrading from version 12.7 to 15.7
>
> On Sat, Feb 15, 2025, 2:15 PM Ron Johnson  wrote:
>
>> On Sat, Feb 15, 2025 at 2:01 PM Yongye Serkfem 
>> 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//data
>>
>> Thus, something as simple as this would work for us:
>> pgswitch() { export PGDATA=/Database/${1}/data ; }
>>
>> --
>> Death to , and butter sauce.
>> Don't boil me, I'm still alive.
>>  lobster!
>>
>

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