From owner-freebsd-ports@FreeBSD.ORG Tue Sep 21 07:15:50 2010 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 85F11106564A for ; Tue, 21 Sep 2010 07:15:50 +0000 (UTC) (envelope-from alp@rsu.ru) Received: from mail.r61.net (mail.r61.net [195.208.245.249]) by mx1.freebsd.org (Postfix) with ESMTP id E3A458FC18 for ; Tue, 21 Sep 2010 07:15:49 +0000 (UTC) Received: from pyhalov.cc.rsu.ru (pyhalov.cc.rsu.ru [195.208.252.128]) (authenticated bits=0) by mail.r61.net (8.14.4/8.14.1) with ESMTP id o8L7Fk9K064240 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT) for ; Tue, 21 Sep 2010 11:15:46 +0400 (MSD) (envelope-from alp@rsu.ru) Message-ID: <4C985BA2.5060906@rsu.ru> Date: Tue, 21 Sep 2010 11:15:46 +0400 From: Alexander Pyhalov User-Agent: Thunderbird 2.0.0.23 (X11/20091202) MIME-Version: 1.0 To: freebsd-ports@FreeBSD.org Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: Subject: 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: Tue, 21 Sep 2010 07:15:50 -0000 Hello. 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). How do you advise to solve this problem? Should we compile postgresql from sources and avoid using databases/postgresql*-server ports? -- Best regards, Alexander Pyhalov, system administrator of Computer Center of South Federal University