multiple version running

"philip johnson" <philip.johnson@atempo.com> writes:

is it possible to have 1 postgresql 6.5.3 and a 7.2 running on a same
machine (mandrake 8.1) ?

Certainly: give them separate install directories, data directories,
and port numbers, and away you go.

You might have to install one or the other from source rather than use
RPMs, if your RPMs want to install both versions in the same place.

regards, tom lane

"philip johnson" <philip.johnson@atempo.com> writes:

is it possible to have 1 postgresql 6.5.3 and a 7.2 running on a same
machine (mandrake 8.1) ?

Sure, just run them with different PGDATA directories and different
ports.

-Doug

On Wed, May 22, 2002 at 11:36:59PM +0200, philip johnson wrote:

is it possible to have 1 postgresql 6.5.3 and a 7.2 running on a same
machine (mandrake 8.1) ?

Yes, it's possible, but only one system can listen on the dafault port
on rely on the default incuded library path. The other installation
must run run on a different post an with the LD_LIBRARAY_PATH set to the
dynamic library path

-tb
--
Thomas Beutin tb@laokoon.IN-Berlin.DE
Beam me up, Scotty. There is no intelligent live down in Redmond.

so the easyets way is to create 2 users with different env ?

-----Message d'origine-----
De : Andrew Sullivan [mailto:andrew@libertyrms.com]De la part de Andrew
Sullivan
Envoye : jeudi 23 mai 2002 00:12
A : philip johnson
Objet : Re: [GENERAL] multiple version running

On Thu, May 23, 2002 at 12:07:01AM +0200, philip johnson wrote:

what do you mean "write a wrapper"

If you need to do some things with the old client, and then need to
compare what will happen in the new client, you can write a shell
script which will set the environment up correctly for you, and then
call the desired client program.

A

-----Message d'origine-----
De : Andrew Sullivan [mailto:andrew@libertyrms.com]De la part de Andrew
Sullivan
Envoye : mercredi 22 mai 2002 23:58
A : philip johnson
Objet : Re: [GENERAL] multiple version running

On Wed, May 22, 2002 at 11:58:29PM +0200, philip johnson wrote:

no problem with shared libraries ?

Not as long as they're compiled with the same libs.

You'll have trouble with the client -- psql needs the shared libs.
Write a wrapper to export LD_LIBRARY_PATH, or just use one client or
the other.

A

-----Message d'origine-----
De : Andrew Sullivan [mailto:andrew@libertyrms.com]De la part de Andrew
Sullivan
Envoye : mercredi 22 mai 2002 23:40
A : philip johnson
Objet : Re: [GENERAL] multiple version running

On Wed, May 22, 2002 at 11:36:59PM +0200, philip johnson wrote:

is it possible to have 1 postgresql 6.5.3 and a 7.2 running on a same
machine (mandrake 8.1) ?

Yes, if they have different data areas and listen on different ports.

A

-- 
----
Andrew Sullivan                               87 Mowat Avenue 
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M6K 3E3
+1 416 646 3304 x110

-- 
----
Andrew Sullivan                               87 Mowat Avenue 
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M6K 3E3
+1 416 646 3304 x110

-- 
----
Andrew Sullivan                               87 Mowat Avenue 
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110

is there some env variables to set ?
if yes which one ?

-----Message d'origine-----
De : pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]De la part de Tom Lane
Envoy� : jeudi 23 mai 2002 00:07
� : philip johnson
Cc : pgsql-general@postgresql.org
Objet : Re: [GENERAL] multiple version running

"philip johnson" <philip.johnson@atempo.com> writes:

is it possible to have 1 postgresql 6.5.3 and a 7.2 running on a same
machine (mandrake 8.1) ?

Certainly: give them separate install directories, data directories,
and port numbers, and away you go.

You might have to install one or the other from source rather than use
RPMs, if your RPMs want to install both versions in the same place.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

On Thu, May 23, 2002 at 12:24:04AM +0200, philip johnson wrote:

so the easyets way is to create 2 users with different env ?

Or use one client for both backends.

-- 
----
Andrew Sullivan                               87 Mowat Avenue 
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110

Sure, just have different install directories and ports they run on.

On Wed, 22 May 2002, philip johnson wrote: