From owner-freebsd-questions@FreeBSD.ORG Tue Sep 23 08:33:49 2014 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id EF325EF7 for ; Tue, 23 Sep 2014 08:33:49 +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 92C4419E for ; Tue, 23 Sep 2014 08:33:49 +0000 (UTC) Received: from ox-dell39.ox.adestra.com (no-reverse-dns.metronet-uk.com [85.199.232.226] (may be forged)) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.14.9/8.14.9) with ESMTP id s8N8XZPB029385 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES128-SHA bits=128 verify=NO) for ; Tue, 23 Sep 2014 09:33:42 +0100 (BST) (envelope-from matthew@freebsd.org) Authentication-Results: smtp.infracaninophile.co.uk; dmarc=none header.from=freebsd.org DKIM-Filter: OpenDKIM Filter v2.9.2 smtp.infracaninophile.co.uk s8N8XZPB029385 Authentication-Results: smtp.infracaninophile.co.uk/s8N8XZPB029385; dkim=none reason="no signature"; dkim-adsp=none; dkim-atps=neutral X-Authentication-Warning: lucid-nonsense.infracaninophile.co.uk: Host no-reverse-dns.metronet-uk.com [85.199.232.226] (may be forged) claimed to be ox-dell39.ox.adestra.com Message-ID: <54213056.2050809@freebsd.org> Date: Tue, 23 Sep 2014 09:33:26 +0100 From: Matthew Seaman User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:31.0) Gecko/20100101 Thunderbird/31.1.0 MIME-Version: 1.0 To: freebsd-questions@freebsd.org Subject: Re: pkg cannot install both php5-pgsql and postgresql 9.3 server by default? References: <542126E9.7090209@shopzeus.com> In-Reply-To: <542126E9.7090209@shopzeus.com> Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="Q3BPm9dMBo388Vvoh928MuCOp8J8REBQO" X-Virus-Scanned: clamav-milter 0.98.4 at lucid-nonsense.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-0.9 required=5.0 tests=AWL,BAYES_00,RDNS_NONE, SPF_SOFTFAIL autolearn=no autolearn_force=no version=3.4.0 X-Spam-Checker-Version: SpamAssassin 3.4.0 (2014-02-07) on lucid-nonsense.infracaninophile.co.uk X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.18-1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 23 Sep 2014 08:33:50 -0000 This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --Q3BPm9dMBo388Vvoh928MuCOp8J8REBQO Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable On 09/23/14 08:53, Nagy L=C3=A1szl=C3=B3 Zsolt wrote: > I need postgresql server 9.3 because I need to use materialized views. = I > also need to access that server from PHP. But pkg won't install them > both at the same time. See below. >=20 > How to overcome this problem? Should I compile php5-pgsql from the port= s > tree? But then I'll be mixing binary packages with ports, isn't that a > problem? >=20 > Thanks >=20 > Laszlo >=20 >=20 >=20 > root@gw:~ # php install php5-pgsql > Could not open input file: install > root@gw:~ # pkg install php5-pgsql > Updating FreeBSD repository catalogue... > FreeBSD repository is up-to-date. > All repositories are up-to-date. > Checking integrity... done (1 conflicting) > Checking integrity... done (0 conflicting) > The following 4 packages will be affected (of 0 checked): >=20 > Installed packages to be REMOVED: > postgresql93-client-9.3.5 > postgresql93-server-9.3.5 >=20 > New packages to be INSTALLED: > php5-pgsql: 5.4.32 > postgresql92-client: 9.2.9 >=20 > The operation will free 16 MB. >=20 > Proceed with this action? [y/N]: n > root@gw:~ # Yes, currently if you want to use non-standard version of postgresql or other programs, then you need to compile them yourself -- and also the other ports that depend on postgresql. Yes, you can do this: the old folk wisdom about "don't mix packages and ports" is outmoded now we are living in the bright new dawn of pkg(8). Just be aware of the time lag between ports being updated in the tree and compiled packages hitting the repositories (about 4 to 10 days depending). Building your own packages with poudriere and creating your own local repo is highly recommended for this -- you can easily just build the packages you want to customize (non-standard options, different versions etc.) locally, but rely on the generic packages for anything else. Cheers, Matthew --Q3BPm9dMBo388Vvoh928MuCOp8J8REBQO Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQJ8BAEBCgBmBQJUITBdXxSAAAAAAC4AKGlzc3Vlci1mcHJAbm90YXRpb25zLm9w ZW5wZ3AuZmlmdGhob3JzZW1hbi5uZXQxOUYxNTRFQ0JGMTEyRTUwNTQ0RTNGMzAw MDUxM0YxMEUwQTlFNEU3AAoJEABRPxDgqeTnjfIP/R2DySZqk8ePShl5Sf2HmlX8 KEKVU9mZg4CHgvk+EGwvdT/XDg+xKD16xOLRJN+5h+3IW+AQRYu9SIc/P0cQmHO9 R3Rhw8CWyJzREHlfL6fQdoG9/VjZ+dmNPyHy/u3hwpRCLKfWh+QQIkJo36rR8oYQ TI42VSlXSdDoSwhKLvTry+IuJGks/iL8tiYr54oF6P+Qba0oPzwoRYJkOT0tdG74 IGiNbYu26xwTBaYhaxb5KbjNSevCd2AhFeTeHTqYhNjI7uJhJILWFbUv3/ORsAEb zR5gU5LQXGwI/ja1v1GuA+U4t3W5E2QlfOkndY3YAi8VVGPj3cXD2iXaJqMxBtsd d21RkAgHo1evLhzRlzdXjHJaxXGdeOINq6ly3kNZBBdAUJwTb6QBUYNNqoSQ0x6G jSW6GX0KvjwQafh6Imj9t6UziYOGIgvbrNlLMwuo1kkh34XW6PGroY0vab5GBv57 JhGtZunsNUa28AwAlTFMEUU/9S31EbABRYwyBKFXul42bEGiYQj+gZBE/2MjFD+9 IUHCAZEWv2neXo1v7ILloCAcv6I3IUZvDXwyRuT2QzUrwWKLNKE9UPZ1QqKdf+sZ d3URnckobDyxNUUaWV7FnRnIm8EKY7a3kHbm133Epx6h+Tc4uCV1ocycOelDF5vJ uSTRiSm8Y+pqpX6o894y =BBdP -----END PGP SIGNATURE----- --Q3BPm9dMBo388Vvoh928MuCOp8J8REBQO--