Try setting DEFAULT_VERSIONS=pgsql=9.6 in /etc/make.conf. Then any
ports that use postgres will have to be rebuilt from ports instead of
installed through pkg.
-Alan
On Tue, Mar 28, 2017 at 12:24 PM, Jim Ohlstein <jim at ohlste.in>
wrote:> Hello,
>
> [cc'ing to ports mailing list since it seems more appropriate there]
>
> On 3/28/17 10:25 AM, ml at ft-c.de wrote:
>>
>> Hello,
>>
>> when I update/upgrade freebsd with pkg,
>> pkg would install the postgresql93-client,
>> but postgresql* version 9.6 is installed.
>
>
>
> It appears as though $something that you are trying to upgrade has a
> dependency on postgresql-client. Since postgresql93 is the default version
> for FreeBSD packages, $something is built against postgresql93-client, and
> is trying to pull it in as a dependency. That would cause
> postgresql96-client to be deinstalled, which would then cause pretty much
> anything postgresql96 related to be removed. Those packages are locked,
> hence the failure.
>
>
>>
>> What's going wrong?
>> Have someoen a solution?
>>
>> I get the following messages:
>>
>> % pkg upgrade
>> Updating FreeBSD repository catalogue...
>> FreeBSD repository is up-to-date.
>> All repositories are up-to-date.
>>
>> postgresql96-plpython-9.6.0_1 is locked and may not be modified
>> postgresql96-plperl-9.6.0_1 is locked and may not be modified
>> postgresql96-contrib-9.6.1 is locked and may not be modified
>> pgtcl-postgresql96-2.0.0_1 is locked and may not be modified
>> pgadmin3-1.22.1_3 is locked and may not be modified
>> pgtcl-postgresql96-2.0.0_1 is locked and may not be modified
>> postgresql96-server-9.6.1_1 is locked and may not be modified
>> pgadmin3-1.22.1_3 is locked and may not be modified
>> pgadmin3-1.22.1_3 is locked and may not be modified
>> pgadmin3-1.22.1_3 is locked and may not be modified
>> postgresql96-contrib-9.6.1 is locked and may not be modified
>> pgadmin3-1.22.1_3 is locked and may not be modified
>> pgadmin3-1.22.1_3 is locked and may not be modified
>> postgresql96-plperl-9.6.0_1 is locked and may not be modified
>> postgresql96-client-9.6.1 is locked and may not be modified
>> postgresql96-plperl-9.6.0_1 is locked and may not be modified
>> postgresql96-client-9.6.1 is locked and may not be modified
>> postgresql96-plpython-9.6.0_1 is locked and may not be modified
>> pgadmin3-1.22.1_3 is locked and may not be modified
>> postgresql96-server-9.6.1_1 is locked and may not be modified
>> postgresql96-client-9.6.1 is locked and may not be modified
>> pgadmin3-1.22.1_3 is locked and may not be modified
>> pgadmin3-1.22.1_3 is locked and may not be modified
>> postgresql96-server-9.6.1_1 is locked and may not be modified
>> postgresql96-contrib-9.6.1 is locked and may not be modified
>> pgadmin3-1.22.1_3 is locked and may not be modified
>> postgresql96-client-9.6.1 is locked and may not be modified
>> postgresql96-client-9.6.1 is locked and may not be modified
>>
>> The following 32 package(s) will be affected (of 0 checked):
>>
>> New packages to be INSTALLED:
>> postgresql93-client: 9.3.15_1
>>
>> Installed packages to be UPGRADED:
>> php70-zlib: 7.0.16 -> 7.0.17
>> ... (more)
>> php70-pgsql: 7.0.16 -> 7.0.17
>> php70-pdo_sqlite: 7.0.16 -> 7.0.17
>> php70-pdo_pgsql: 7.0.16 -> 7.0.17
>> php70-pdo: 7.0.16 -> 7.0.17
>> ... (more)
>> nspr: 4.13.1 -> 4.14
>> mod_php70: 7.0.16 -> 7.0.17
>> git: 2.11.0_3 -> 2.12.1
>>
>> Installed packages to be REINSTALLED:
>> apache24-2.4.25_1 (options changed)
>>
>> Number of packages to be installed: 1
>> Number of packages to be upgraded: 30
>> Number of packages to be reinstalled: 1
>>
>> The process will require 10 MiB more space.
>> 234 KiB to be downloaded.
>>
>>
>>
>> % pkg upgrade git
>> Updating FreeBSD repository catalogue...
>> FreeBSD repository is up-to-date.
>> All repositories are up-to-date.
>> pgtcl-postgresql96-2.0.0_1 is locked and may not be modified
>> ... (more: see above)
>>
>> Checking integrity...
>> Assertion failed: (cun != NULL), function
>> pkg_conflicts_check_chain_conflict, file pkg_jobs_conflicts.c, line
499.
>> Child process pid=2230 terminated abnormally: Abort trap
>>
>>
>>
>> % uname -a
>> FreeBSD ftc2 11.0-RELEASE-p2 FreeBSD 11.0-RELEASE-p2 #0: Mon Oct 24
>> 06:55:27 UTC 2016
>> root at amd64-builder.daemonology.net:/usr/obj/usr/src/sys/GENERIC
amd64
>>
>>
>
> --
> Jim Ohlstein
>
>
> "Never argue with a fool, onlookers may not be able to tell the
difference."
> - Mark Twain
>
> _______________________________________________
> freebsd-stable at freebsd.org mailing list
> https://lists.freebsd.org/mailman/listinfo/freebsd-stable
> To unsubscribe, send any mail to "freebsd-stable-unsubscribe at
freebsd.org"