pkg cannot install both php5-pgsql and postgresql 9.3 server by default?

[Matthew Seaman]

On 09/23/14 08:53, Nagy László 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.
> 
> How to overcome this problem? Should I compile php5-pgsql from the ports
> tree? But then I'll be mixing binary packages with ports, isn't that a
> problem?
> 
> Thanks
> 
>     Laszlo
> 
> 
> 
> root at gw:~ # php install php5-pgsql
> Could not open input file: install
> root at 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):
> 
> Installed packages to be REMOVED:
>         postgresql93-client-9.3.5
>         postgresql93-server-9.3.5
> 
> New packages to be INSTALLED:
>         php5-pgsql: 5.4.32
>         postgresql92-client: 9.2.9
> 
> The operation will free 16 MB.
> 
> Proceed with this action? [y/N]: n
> root at 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





-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 949 bytes
Desc: OpenPGP digital signature
URL: <http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20140923/7650b8c0/attachment.sig>