Solved Can not install pgAdmin III and PostgreSQL 9.6

I have been install postgresql96-server and postgresql96-client. I want to install pgAdmin III GUI tool to manage PostgreSQL.

It show I have to removed postgresql96-server and postgresql96-client when I install pgadmin3.
But I need to using PostgreSQL 9.6 So I don't want removed it.

I try to set a make.conf in /etc but it no use. How do I solve the problem?

$ freebsd-version

$ sudo touch /etc/make.conf
$ sudo nano /etc/make.conf
$ cat /etc/make.conf

$ sudo pkg install pgadmin3
Updating FreeBSD repository catalogue...
FreeBSD repository is up-to-date.
All repositories are up-to-date.
pkg: gstreamer1-plugins-lame has a missing dependency: lame
Checking integrity... done (2 conflicting)
  - postgresql93-client-9.3.14_1 conflicts with postgresql96-client-9.6.0 on /usr/local/bin/clusterdb
  - postgresql93-client-9.3.14_1 conflicts with postgresql96-client-9.6.0 on /usr/local/bin/clusterdb
Checking integrity... done (0 conflicting)
The following 4 package(s) will be affected (of 0 checked):

Installed packages to be REMOVED:

New packages to be INSTALLED:
   pgadmin3: 1.22.1_2
   postgresql93-client: 9.3.14_1

Number of packages to be removed: 2
Number of packages to be installed: 2

Proceed with this action? [y/N]: n
Last edited:
I'm sorry.
I should post this to "Installation and Maintenance of Ports or Packages".

How do I delete the thread, thanks.
If you want to deviate from the defaults you'll need to build from ports. Packages have set dependencies that cannot be changed after the package is created.

$ cat /etc/make.conf DEFAULT_VERSIONS=pgsql=9.6
This only has effect for ports, it does nothing for packages.
Thanks your reply, SirDice.

I try to build from ports but it show PostgreSQL 9.6 is not valid version.
Does pgAdmin3 1.22.1 can not support PostgreSQL 9.6 ?

What sould I do for next?

$ sudo freebsd-update fetch
Looking up mirrors... none found.
Fetching metadata signature for 11.0-RELEASE from done.
Fetching metadata index... done.
Inspecting system... done.
Preparing to download files... done.

No updates needed to update system to 11.0-RELEASE-p1.
$ sudo freebsd-update install
No updates are available to install.
Run '/usr/sbin/freebsd-update fetch' first.

$ pwd
$ sudo make install clean
===>  pgadmin3-1.22.1_2 Invalid PGSQL default version 9.6; valid versions are
9.0 9.1 9.2 9.3 9.4 9.5.
*** Error code 1

make: stopped in /usr/ports/databases/pgadmin3
Last edited: