X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4BEFFD1B193 for ; Sun, 23 May 2004 19:25:50 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 64473-01 for ; Sun, 23 May 2004 19:25:31 -0300 (ADT) Received: from tomts25-srv.bellnexxia.net (tomts25-srv.bellnexxia.net [209.226.175.188]) by svr1.postgresql.org (Postfix) with ESMTP id 03284D1B176 for ; Sun, 23 May 2004 19:25:28 -0300 (ADT) Received: from zoom ([209.226.248.22]) by tomts25-srv.bellnexxia.net (InterMail vM.5.01.06.10 201-253-122-130-110-20040306) with SMTP id <20040523222528.HDVI987.tomts25-srv.bellnexxia.net@zoom> for ; Sun, 23 May 2004 18:25:28 -0400 Message-ID: <000901c44114$d58aa0c0$3410fea9@zoom> From: "Paul Gimpelj" To: References: <001001c43f03$476e9de0$3410fea9@zoom> Subject: Re: two versions on same linux Date: Sun, 23 May 2004 18:25:19 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200405/242 X-Sequence-Number: 13558 thanks, I used tar.gz version, now trying to get regression working. I want two simo servers. Any suggestions on port numbers? ----- Original Message ----- From: "Christopher Browne" To: Sent: Friday, May 21, 2004 8:19 AM Subject: Re: [ADMIN] two versions on same linux > A long time ago, in a galaxy far, far away, pgimpelj@sympatico.ca ("Paul Gimpelj") wrote: > > I have redhat 7.3 and postgres 7.2 > > > > Is there a way to have 7.4 installed together with postgres 7.2 ? and both running at the same time, > > > > with of course different data directories. > > > > should i use the generic postgres or the rpm'd. > > Presumably the respective RPMs will conflict between the different > versions, which is a bit of a problem. > > You could of course install one or the other or even both from source, > as long as you choose a specific place to stick them. > > Under the circumstances, I'd be inclined to do this: > > - Install the PG 7.4 RPMs, in order to have things like Perl support > managed by the package management system. > > Personally, I'd rather stick hot needles in my eyes (add further > gruesome details as needed ;-)) than manage Perl stuff by hand. > > - Install PG 7.2 AND 7.4 in source code form in some place that YOU > manage, and run the database clusters out of that. > > A naming convention could be to stick them in /opt; you'd configure > the source builds something like: > > %postgresql-7.2.5> ./configure --prefix=/opt/postgres/7.2.5 > [then build and install 7.2.5] > > %postgresql-7.4.2> ./configure --prefix=/opt/postgres/7.4.2 > [then build and install 7.4.2] > > You'd need to customize both "init" scripts in /etc/rc.d, perhaps > basing them on the ones provided by the RPM file. > > > The existing redhat has no passwords for postgres, and even if if > > assign one to user postgres, > > > > postgres ignores it. > > That's probably based on the ACLs configured in the pg_hba.conf file; > if there are "trust" entries there, passwords can get ignored... > -- > (reverse (concatenate 'string "gro.mca" "@" "enworbbc")) > http://www.ntlug.org/~cbbrowne/emacs.html > "We live in a Newtonian world of Einsteinian physics ruled by > Frankenstein logic." -- David Russell > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >