If a system already has postgresql93-(server|client)-9.3.5 installed, attempting to install py27-psycopg2-2.5.3 causes pkg to remove the existing postgres packages, and install only postgresql92-client-9.2.9 in their place. Can the psycopg2 package be updated to use/support the latest/future postgres package(s)?
Maintainers CC'd
root@devbox:~ # pkg install py27-psycopg2-2.5.3 Updating FreeBSD repository catalogue... FreeBSD repository is up-to-date. All repositories are up-to-date. The following 2 packages will be affected (of 0 checked): New packages to be INSTALLED: py27-psycopg2: 2.5.3 postgresql92-client: 9.2.9 The process will require 10 MB more space. 2 MB to be downloaded. Proceed with this action? [y/N]: y Fetching py27-psycopg2-2.5.3.txz: 100% 274 KB 280.3k/s 00:01 Fetching postgresql92-client-9.2.9.txz: 100% 2 MB 633.4k/s 00:03 Checking integrity... done (1 conflicting) Checking integrity... done (0 conflicting) Conflicts with the existing packages have been found. One more solver iteration is needed to resolve them. The following 4 packages will be affected (of 0 checked): Installed packages to be REMOVED: postgresql93-server-9.3.5 postgresql93-client-9.3.5 New packages to be INSTALLED: postgresql92-client: 9.2.9 py27-psycopg2: 2.5.3 The operation will free 15 MB. Proceed with this action? [y/N]:
This is likely related to the current value for PGSQL_DEFAULT from head/Mk/bsd.default-versions.mk. Uses may use DEFAULT_VERSIONS set in /etc/make.conf to set alternate values. Can you try setting this and letting us know if that resolves the issue for you.
Thanks for the suggestion. I just tried this and it still seems to want to blast away pgsql 9.3 client+server and only install 9.2 client. Does the new pkg tool take that setting in to account, or will I just have to install psycopg using ports rather than pkg for the time being? (In reply to Kubilay Kocak from comment #3) > This is likely related to the current value for PGSQL_DEFAULT from > head/Mk/bsd.default-versions.mk. > > Uses may use DEFAULT_VERSIONS set in /etc/make.conf to set alternate values. > Can you try setting this and letting us know if that resolves the issue for > you.
Port requires conversion to USES=pgsql (thanks antoine@)
The short answer is that you must use the port, (i.e. cd /usr/ports/databases/py-psocypg2; make install) to install software depending on a "non-default" postgresql version. This is a design limitation. The default PostgreSQL version is 9.2. This is the only version for which you can use prebuilt packages to install dependant software. For example, there is only one py-psycopg2 port. It is built against postgresql92-client. The resulting package is py27-psycopg2. There is no package automaticially built for python32 or postgresql93. The default packages are built with the default set of versions, for example python27 and postgresql92. Another way to design this would be to have different ports for different versions of postgresql, e.g. py27-pg92-psycopg2, py27-pg93-psycopg2 and so on. No-one has stepped forward to actually do this, and I am not entirely sure that it is even a good idea, given the complexity and the amount of ports this would require. With five versions of postgresql and four versions of python, we would get 20 ports for psycopg2 alone =). Even with a framework where one port would create 20 packages, the complexity of it all is still a bit overwhelming.
A tip is to use poudriere to built your own package set.