Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 16 Dec 2014 11:51:14 +0100
From:      Francois Tigeot <ftigeot@wolfpond.org>
To:        freebsd-ports@freebsd.org
Subject:   Re: Discrepancy in postgresql entry in UPDATING
Message-ID:  <20141216105114.GB379084@sekishi.zefyris.com>
In-Reply-To: <548F8DCA.8070407@bluerosetech.com>
References:  <548F8DCA.8070407@bluerosetech.com>

next in thread | previous in thread | raw e-mail | index | archive | help
On Mon, Dec 15, 2014 at 05:41:30PM -0800, Darren Pilgrim wrote:
> The entry reads:
> 
> 20141208:
[...]
>    When using binary packages, if you only use the client port, you can
>    issue the following command to follow the default version:
> 
>    # pkg set -o databases/postgresql92-client:databases/postgresql93-client
> 
> The problem is pg_upgrade requires both the old and new versions be 
> installed concurrently--something pkg/ports can't do.  So how are we 
> supposed to upgrade?

With pg_upgrade, I found the best method to be:

- locally build the two postgres versions you're interested in from the
  Postgres distfiles.
- run pg_upgrade from one of them

and don't bother with the packages.

The Postgres packages are fine for regular operation but like you said,
not really adapted for this kind of one shot operation IMHO.

-- 
Francois Tigeot



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20141216105114.GB379084>