This is part of The Pile, a partial archive of some open source mailing lists and newsgroups.
To: pgsql-general-postgresql.org@localhost.postgresql.org Date: 01 Jul 2003 01:21:14 -0400 From: Arguile <arguile@lucentstudios.com> Subject: Re: [GENERAL] 2 different versions of postgres on the same system Date: 01 Jul 2003 01:21:14 -0400 Madhavi Daroor wrote: > 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. === To: pgsql-general-postgresql.org@localhost.postgresql.org Date: Tue, 1 Jul 2003 06:39:15 -0600 (MDT) From: "scott.marlowe" <scott.marlowe@ihs.com> Subject: Re: [GENERAL] 2 different versions of postgres on the same system Madhavi Daroor wrote: > 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. === To: pgsql-general-postgresql.org@localhost.postgresql.org Date: Tue, 1 Jul 2003 06:39:59 -0600 (MDT) From: "scott.marlowe" <scott.marlowe@ihs.com> Subject: Re: [GENERAL] 2 different versions of postgres on the same system Madhavi Daroor wrote: > 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. ===