Обсуждение: 2 different versions of postgres on the same system
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
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.
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.
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.