From owner-freebsd-ports@FreeBSD.ORG Sat Sep 29 08:49:28 2012 Return-Path: Delivered-To: freebsd-ports@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 8B06D106566C for ; Sat, 29 Sep 2012 08:49:28 +0000 (UTC) (envelope-from Axel.Rau@Chaos1.DE) Received: from mailout4.lrau.net (mailout4.lrau.net [IPv6:2a02:d40:2:2::73]) by mx1.freebsd.org (Postfix) with ESMTP id 1EB8B8FC0A for ; Sat, 29 Sep 2012 08:49:25 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=chaos1.de; s=email; h=To:References:Message-Id:Content-Transfer-Encoding:Date:In-Reply-To:From:Subject:Mime-Version:Content-Type; bh=n19ELpPcl4KYoJJb1MzvSt0sjFZ8e/GYoTH4npevGp4=; b=DApPKt23JVjcfc9DqNAshGSE0pcRye+HHu0Tfrd8tJF8JVJtxqWtL+75YxjumNJVo38Rpu28DGLwbtwhN4KkrTMB/BYh5O6Vo6PrEnp/J5L/1ATeP8VGFJNbMFidkSjurMU/z3ly8pnQZk8N1k1vyOfENfMHMVVdXP/XOUhJiv0=; Received: from [91.216.35.74] (helo=imap.lrau.net) by mailout4.lrau.net with esmtp (Exim 4.80_DBL (FreeBSD)) (envelope-from ) id 1THsjk-000NKV-EN for freebsd-ports@freebsd.org; Sat, 29 Sep 2012 08:49:24 +0000 Received: from axel.rau@chaos1.de by imap.lrau.net (Archiveopteryx 3.1.4) with esmtpsa id 1348908563-16266-16265/7/196; Sat, 29 Sep 2012 08:49:23 +0000 Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Apple Message framework v1085) From: Axel Rau In-Reply-To: <4C985BA2.5060906@rsu.ru> Date: Sat, 29 Sep 2012 10:49:16 +0200 Content-Transfer-Encoding: quoted-printable Message-Id: <3000A63E-F860-45B1-B2C4-EAC7F0BF9BA3@Chaos1.DE> References: <4C985BA2.5060906@rsu.ru> To: freebsd-ports@freebsd.org X-Mailer: Apple Mail (2.1085) Subject: Re: Question about postgresql 9 and pg_upgrade X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 29 Sep 2012 08:49:28 -0000 Am 21.09.2010 um 09:15 schrieb Alexander Pyhalov: > All latest PostgreSQL ports has conflicts with earlier versions. May = this be corrected in some way (for example, modify CONFLICTS variable = and install each new PostgreSQL version in its own directory, e.g. = ${LOCALBASE}/postgresql/XX/, where XX is 90 , 91 and so on). This will = allow us to use pg_upgrade to upgrade databases (it needs binary files = from both new and old postgresql version). >=20 > How do you advise to solve this problem? Should we compile postgresql = from sources and avoid using databases/postgresql*-server ports? Did anybody find a good solution for this? I'm just planning upgrade from 9.1.x to 9.2.x. Axel =2D-- PGP-Key:29E99DD6 =E2=98=80 +49 151 2300 9283 =E2=98=80 computing @ = chaos claudius