Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id B6E3D9FA312 for ; Tue, 30 Jan 2007 13:19:55 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 61389-03-3 for ; Tue, 30 Jan 2007 13:19:48 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 1DB929FB421 for ; Tue, 30 Jan 2007 13:15:38 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.8/8.13.8) with ESMTP id l0UHFbVh065952 for ; Tue, 30 Jan 2007 13:15:37 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.8/8.13.8/Submit) id l0UH0kOd061075 for pgsql-admin@postgresql.org; Tue, 30 Jan 2007 13:00:46 -0400 (AST) (envelope-from news) From: "codeWarrior" X-Newsgroups: pgsql.admin Subject: Re: postgres-two different version Date: Tue, 30 Jan 2007 09:04:15 -0800 Organization: iDynaTECH, Inc. Lines: 37 Message-ID: References: <002101c74464$4d7eea50$ae05a8c0@arpavda.it> <1892.1170169384@sss.pgh.pa.us> Reply-To: "codeWarrior" X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3028 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 X-RFC2646: Format=Flowed; Original To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/275 X-Sequence-Number: 24431 Why would you want two servers on the same box ??? There's this thing called "schemas" within one database... and postgreSQL is very capable of managing multiple databases from the same server.... If you insist on trying to run two postgreSQL server on teh same box -- You also need to make sure that your two different versions dopnt share TCP/IP ports -- they cannot both listen on the same IP:PORT address -- so you will need to manage your postgresql.conf and pg_hba.conf files separately -- one for each postgresql server... ditto for your startup scripts. You will probably also have some issues when using pgsql at the command line [localhost]. Why not just upgrade your 8.1.3 installation to 8.2 ? "Tom Lane" wrote in message news:1892.1170169384@sss.pgh.pa.us... > "Bottini" writes: >> Is possible to install two different version of postgresql on the same >> Linux server? I want to install the 8.2 version in a server where is >> installed 8.1.3 version > > You can, but not when installing from RPM: the RPMs have a fixed idea of > where to put the software, and I don't think it's feasible to change. > You'd need to build from source and use the --prefix configure option > to put the two sets of code in different places. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend >