Thread: 2 different versions of postgres on the same system

2 different versions of postgres on the same system

From
"Madhavi Daroor"
Date:
Hi all,
     I have installed postgres 7.3 in my Red hat linux 7.2 system. I want to
also install postgres 7.2.3 in the same system. Is it possible?? Can
somebody please tell me how I can do this...ASAP!!!

Regards,
Madhavi



Re: 2 different versions of postgres on the same system

From
Arguile
Date:
On Tue, 2003-07-01 at 01:12, Madhavi Daroor wrote:
> Hi all,
>      I have installed postgres 7.3 in my Red hat linux 7.2 system. I want to
> also install postgres 7.2.3 in the same system. Is it possible?? Can
> somebody please tell me how I can do this...ASAP!!!

Easy, just change the PREFIX to a different location when you compile
and initdb in a different dir than the first. If you plan to use TCP/IP
you'll probably want to specify a different default port as well.

If you don't create/user a seperate user than your main Pg(for the
PGDATA, etc. env vars) just make sure to call /full/path/to/pg_ctl and
specify where it's data resides with the -D flag.


Re: 2 different versions of postgres on the same system

From
"scott.marlowe"
Date:
On Tue, 1 Jul 2003, Madhavi Daroor wrote:

> Hi all,
>      I have installed postgres 7.3 in my Red hat linux 7.2 system. I want to
> also install postgres 7.2.3 in the same system. Is it possible?? Can
> somebody please tell me how I can do this...ASAP!!!

Just what the other message said, with one caveat.  If you're prone to
dumbass attacks (I know I am some days) then install each under a
different account that doesn't have access to the other's directory.  This
has two advantages.  1:  If you're rm -Rf ing the data directory you don't
have to worry about doing it to the wrong one as much, since you're
command prompt will have the account name showing (name the accounts
something like pgsql72 and pgsql73) and 2: You can assign ownership of the
two databases to two different people, and not worry about person1
destroying person2's database.

They need to run on different ports too, of course.


Re: 2 different versions of postgres on the same system

From
"scott.marlowe"
Date:
On Tue, 1 Jul 2003, Madhavi Daroor wrote:

> Hi all,
>      I have installed postgres 7.3 in my Red hat linux 7.2 system. I want to
> also install postgres 7.2.3 in the same system. Is it possible?? Can
> somebody please tell me how I can do this...ASAP!!!

Oh, and you need to ./configure --prefix=/usr/local/pgsql72 for one, and
./configure --prefix=/usr/local/pgsql73 for the other kinda thing too.