From owner-freebsd-pkg@FreeBSD.ORG Fri Apr 11 06:14:29 2014 Return-Path: Delivered-To: freebsd-pkg@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id 5B16D4DD for ; Fri, 11 Apr 2014 06:14:29 +0000 (UTC) Received: from smtp.infracaninophile.co.uk (smtp6.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3cd3:cd67:fafa:3d78]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "smtp.infracaninophile.co.uk", Issuer "ca.infracaninophile.co.uk" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id DCF251900 for ; Fri, 11 Apr 2014 06:14:28 +0000 (UTC) Received: from seedling.black-earth.co.uk (seedling.black-earth.co.uk [81.2.117.99]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.14.8/8.14.8) with ESMTP id s3B6EL8H073573 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES128-SHA bits=128 verify=NO); Fri, 11 Apr 2014 07:14:22 +0100 (BST) (envelope-from matthew@FreeBSD.org) DKIM-Filter: OpenDKIM Filter v2.8.3 smtp.infracaninophile.co.uk s3B6EL8H073573 Authentication-Results: smtp.infracaninophile.co.uk/s3B6EL8H073573; dkim=none reason="no signature"; dkim-adsp=none Message-ID: <5347883A.5060805@FreeBSD.org> Date: Fri, 11 Apr 2014 07:14:18 +0100 From: Matthew Seaman User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:24.0) Gecko/20100101 Thunderbird/24.4.0 MIME-Version: 1.0 To: Dmitry Morozovsky , Steven Schlansker Subject: Re: Installing bacula-server with PostgreSQL 9.2 References: <413DCEA9-DE6D-4834-B9F1-6C08C7BE5F2C@likeness.com> <533CF8EB.7090403@FreeBSD.org> <6534BBBF-4D98-4FCB-A9AC-4564B0373E08@gmail.com> In-Reply-To: X-Enigmail-Version: 1.6 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="xeQJb2bbPoLtGEUA0l0mmK2veRjJe74qp" X-Virus-Scanned: clamav-milter 0.98.1 at lucid-nonsense.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-2.9 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00 autolearn=ham autolearn_force=no version=3.4.0 X-Spam-Checker-Version: SpamAssassin 3.4.0 (2014-02-07) on lucid-nonsense.infracaninophile.co.uk Cc: freebsd-pkg@freebsd.org X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.17 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 11 Apr 2014 06:14:29 -0000 This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --xeQJb2bbPoLtGEUA0l0mmK2veRjJe74qp Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable On 11/04/2014 00:22, Dmitry Morozovsky wrote: > On Thu, 3 Apr 2014, Steven Schlansker wrote: >=20 >>> The dependency on postgresql90 is "baked into" the compiled package, = and >>> it is not possible to use that package with a different version of >>> postgresql. Apart from anything else, any binaries are linked against= >>> the specific ABI versions of shlibs provided by the postgresql client= >>> package. 'pkg set -o' is not an answer in this case, >> >> That?s very unfortunate! I would expect a binary built against libpq = 9.0 >> to work fine when linked with libpq 9.3, but can?t say that I know exa= ctly >> how good PostgreSQL is about binary compatibility. >=20 > The PostgreSQL team is quite straight about it: there's no promises reg= arding=20 > binary compatibility when you're changing important (in PgSQL case, sec= ond=20 > number) version part; hence, whenever you're drifting from N.M to N.M+1= you're=20 > basically forced to to dump/resore or replication. There were some exc= eptions,=20 > but usually you should be ready to set up new server and then migrate y= our=20 > database one way or another... In fact, the Postgresql project has now declared that point releases incrementing the minor (ie. second part) version number will not need a dump/restore any more. So long as you're using PostgreSQL 9.3 or above. Using replication for upgrades means you have to use trigger based replication ie. Slony -- that's the only replication style that allows different versions either end. Unless you're running at least 9.3, where you can upgrade a streaming replication setup without having to stop, upgrade both ends and restart. Even so, this does not affect the library dependencies for the postgresql binaries. The requirement there is minimally that the library ABI version should not change. I don't know what their policy is -- either forwards + backwards ABI compatibility, or (like the FreeBSD project) forwards compatibility, so a program compiled on FreeBSD 9.0 will work on 9.1, 9.2 etc. but one compiled on 9.2 will not necessarily run on 9.0. The pkg(8) system takes a conservative approach and forces you to install exactly the same versions as used for compilation. The new solver in 1.3 may allow some lattitude in this, but we don't have support for dependencies on ranges of version numbers yet. There's a GSoC proposal to implement that which we're waiting on a decision about. Cheers, Matthew --=20 Dr Matthew J Seaman MA, D.Phil. PGP: http://www.infracaninophile.co.uk/pgpkey --xeQJb2bbPoLtGEUA0l0mmK2veRjJe74qp Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.20 (Darwin) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQJ8BAEBCgBmBQJTR4g8XxSAAAAAAC4AKGlzc3Vlci1mcHJAbm90YXRpb25zLm9w ZW5wZ3AuZmlmdGhob3JzZW1hbi5uZXQ2NTNBNjhCOTEzQTRFNkNGM0UxRTEzMjZC QjIzQUY1MThFMUE0MDEzAAoJELsjr1GOGkATf6cQAJbAQqfbypCTylvUq6AtRPGP uUS64CnblaR1+n4EcBcwpPHCWSQAxeZvxHOOQeni4IoRsLUwZKVGK+hiJGvrzZ7R F8eIyZvljQIfesaUjsn4WijBjSnAXnYSyFdMUlcIcuCK23pIIEPnbGBId0kNSHex PNIKAHOC6CduV8ESaTW5PiyRBLB0tCGbrvIwrYFdl2lZfEDSxoFlw/eLKBj15hwv MERTuuObJkLPjTyuIVkHoQkZeVnrFnPVzYkMn/kJwt62ye5Nw+6RcuwvdPuMybq+ qGxPop96CQz4PcD9k7lNo1dOPYDEFOut4k/w3bCIo1SLomqEh4si1rLlcXNkTHAW mej+veAZNyegm9EEH4RRC644mIDQmIhuK0AhvEuC9+VR1kO99r6hJelE8Jq07vbl PlraXHxywcJVxic7Jlre0EKhqoIjYFmjpxJCCHc3UPyNXj3lMDMJRptl3XXJuB5l Yv2lruIRug1JDtpqWy5FHLm7mjF7HblRaw31v1ARXs8H+i9TVrD/f6HW5GoBARI0 wSG0bjWt99dbWoM1VZ5PbbhkEc3i/z+PB76EskyKKjt23SoeJk3I6eSsAxHXxhpZ qNDDO20wHzeH5yDvEmN4N0KtJ7EooTie+cXthYVAEY7prQOHwfZ8n+2YOaIBb8ye VBnVmc3dYNIUpaeRhFNy =XIZl -----END PGP SIGNATURE----- --xeQJb2bbPoLtGEUA0l0mmK2veRjJe74qp--