Date: Mon, 08 Mar 2010 12:59:09 +0000 From: Matthew Seaman <m.seaman@infracaninophile.co.uk> To: n dhert <ndhertbsd@gmail.com> Cc: freebsd-questions@freebsd.org Subject: Re: mysql,postgresql,client,server Message-ID: <4B94F49D.8@infracaninophile.co.uk> In-Reply-To: <ed7803cf1003080423p72d239c9xa1db8e7958ceda99@mail.gmail.com> References: <ed7803cf1003080423p72d239c9xa1db8e7958ceda99@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 08/03/2010 12:23:04, n dhert wrote:
> MySQL and Postgresql appear in the freebsd with many different versions.
> Normally ports have only one version (the latest) and you upgrade with
> portupgrade.
>
> Sometimes a mysql-client or postgresql-client is installed as a dependency
> of another port,
> (e.g. a Davical install today installed postgresql-client-8.2.15_1 as a
> dependency whereas
> postgresql-server already has a 8.3 and 8.4 version in the ports now)
> Is it save to install the newest server version?
> or should one install the same version as the client one already has ?
Yes, in general you can install whichever versions of the DB client you
prefer. The ports generally defaults to a conservatively chosen
version - sometimes this can be an older version than what the upstream
project itself recommends. Unless you are going to be exploring less
frequently used or novel functionality and if you're not concerned with
getting the absolute maximum performance, then the newest versions are
generally OK.
> Both for mysql and postgresq server, the corresponding client is a
> dependendy.
> I e.g. you already have mysql-client-5.0.90 but no mysql server yet, and you
> install
> mysql-server-5.5.2., will it install mysql-client-5.5.2 alongside the
> existing mysql-client-5.0.90
> or upgrade it ?
The -server ports link against shared libraries provided by the -client
ports: this means that you have to have matching server and client
ports installed on a server. As mysql-client-5.0.90 conflicts with
mysql-client-5.5.2 you'll find simply trying to install mysql-
server-5.5.2 will fail. Instead, try something like this:
# portupgrade -m DISABLE_CONFLICTS=yes -o databases/mysql55-client -f
mysql-client-5.0.90
# portupgrade -x mysql-client-5.5.2 -fr mysql-client-5.5.2
# portinstall databases/mysql55-server
Note: if you have mysql50-scripts installed, you'll need to insert this
as the 2nd step:
# portupgrade -m DISABLE_VULNERABILITIES=yes -o
databases/mysql55-scripts -f mysql-scripts-5.0.90
Once you've got mysql-5.5.2 installed, any other ports you install
which depend on MySQL will automatically link against that version.
Well, with the possibility there might be a few ports known not to work
with that specific version.
Cheers,
Matthew
- --
Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard
Flat 3
PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate
Kent, CT11 9PW
-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.14 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEARECAAYFAkuU9J0ACgkQ8Mjk52CukIw3JACfTJOHLS7KQ6Qk81Pj8JNrph3G
EmYAoIeL0iDomMXeVnBeAULRN6SjQmS+
=Rm4i
-----END PGP SIGNATURE-----
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4B94F49D.8>