Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 23 Nov 2015 11:58:58 +0000
From:      bugzilla-noreply@freebsd.org
To:        freebsd-ports-bugs@FreeBSD.org
Subject:   [Bug 201796] Mk/bsd.default-versions.mk: Set PostgreSQL 9.4 as default
Message-ID:  <bug-201796-13-VQOPesNHub@https.bugs.freebsd.org/bugzilla/>
In-Reply-To: <bug-201796-13@https.bugs.freebsd.org/bugzilla/>
References:  <bug-201796-13@https.bugs.freebsd.org/bugzilla/>

next in thread | previous in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D201796

--- Comment #14 from Mathieu Arnold <mat@FreeBSD.org> ---
(In reply to Palle Girgensohn from comment #13)
> (In reply to Torsten Z=C3=BChlsdorff from comment #12)
>=20
> Vi had a discussion about this within the pgsql@ team, and one way might =
be
> to extract libpq to a separate port, och make USES=3Dpgsql just pull in t=
hat
> dependency. That would always be the latest version, since libpq is very
> stable, it rarely changes at all. Then we could install the rest of
> postgresqlNN-client and postgresqlNN-server in it's own
> (lib|share|include)/postgresqlNN directories, and use some kind of meta-p=
ort
> to symlink to the preferred version.
>=20
> It would mean we could install several postgresql versions in parallel. T=
his
> is a complex task though, and it might not even be completely possible
> without too much intrusive changes to postgresql. I will discuss this with
> some other packagers first. So this should probably be regarded as a
> possible long term solution at best.
>=20
> We do however need some way of helping users to get two different versions
> of postgresql binaries in just for the sake of facilitating an upgrade
> running pg_upgrade. The most simple way would probably be a separate port,
> but that woud be a bit weird.
>=20
> Other ideas?

Moving pg_upgrade from -contrib to -server would be great, people have been
asking this for a long time.

Most package systems are able to install more than one postgresql at a time,
though we don't really need that, what we need is to be able to upgrade, it
means that there should be a package with older bin/postgres binaries (it's=
 the
only one needed for pg_upgrade, along with the .so it needs, of course.)

Maybe the postgresqlXX-server package could include them.

--=20
You are receiving this mail because:
You are on the CC list for the bug.=



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-201796-13-VQOPesNHub>