From owner-freebsd-ports@FreeBSD.ORG Sat Sep 29 09:42:04 2012 Return-Path: Delivered-To: freebsd-ports@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 079BF106564A; Sat, 29 Sep 2012 09:42:04 +0000 (UTC) (envelope-from utisoft@gmail.com) Received: from mail-bk0-f54.google.com (mail-bk0-f54.google.com [209.85.214.54]) by mx1.freebsd.org (Postfix) with ESMTP id 5C4B18FC18; Sat, 29 Sep 2012 09:42:02 +0000 (UTC) Received: by bkcjf20 with SMTP id jf20so3252956bkc.13 for ; Sat, 29 Sep 2012 02:41:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=Gc3deWYQNTFNZLWLM7Xr7/UKKlsmMVzvX/8RIl/KoZw=; b=pi76RxnyHvTLbUmMoNwnLedGKHCAYHiOrPscR8rU55PT90R1/8EcRMjCfZLlw6i2FX aI4tax9tSjxNrAu3O3YsIe4WTe8oWbSMEs4eb0WZ/u5kfTc2CtXKyqcJVEEZ2L7AJEl6 rDOcrw8Mnk6DZxSwjaCrvlxEFblUjQUBPX6JrEWJWSIsLdF7GbCH4HHJhfe6txPndrhM NGyxaTX8KtFIolUdDpNp99tJptaL373jFIYtbKhljzBMetP7d3QE1h4i0CXs3IwEyP5g pLIijjFg92ZB706EQ4WEap7kU+eG2YxlRfw1AN9H/y48F4zNtuJhqX5r3FuIbx4uJYdo M7GA== MIME-Version: 1.0 Received: by 10.204.4.129 with SMTP id 1mr4709009bkr.58.1348911715568; Sat, 29 Sep 2012 02:41:55 -0700 (PDT) Received: by 10.204.10.141 with HTTP; Sat, 29 Sep 2012 02:41:55 -0700 (PDT) Received: by 10.204.10.141 with HTTP; Sat, 29 Sep 2012 02:41:55 -0700 (PDT) In-Reply-To: <3000A63E-F860-45B1-B2C4-EAC7F0BF9BA3@Chaos1.DE> References: <4C985BA2.5060906@rsu.ru> <3000A63E-F860-45B1-B2C4-EAC7F0BF9BA3@Chaos1.DE> Date: Sat, 29 Sep 2012 10:41:55 +0100 Message-ID: From: Chris Rees To: Axel Rau , Alexander Pyhalov Content-Type: text/plain; charset=ISO-8859-1 X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: pgsql@freebsd.org, freebsd-ports@freebsd.org 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 09:42:04 -0000 On 29 Sep 2012 09:49, "Axel Rau" wrote: > > > 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). > > > > 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. Sorry for the delay in replying (major delay!) We (pgsql@) are dreamily considering ways to mitigate this problem, by perhaps versioning the data directories, but the sad fact is that its going to be pretty difficult to do without migration by most people on upgrades. Added to the fact that databases are almost always mission-critical, we're reluctant to mess about until something's properly tested. Sorry to say, but the only current upgrade path is stop database, dump, upgrade, restore, restart. Minimum downtime is; # cd /usr/ports/databases/postgresql92-server # make # service postgresql stop (dump database) # pkg_delete -fx postgresql-server # make install clean (Restore database) # service postgresql start I hope we'll have a solution soon. Chris