Solved Can not install pgAdmin III and PostgreSQL 9.6

fbsdgo

fbsdgo

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?

Code: 
$ freebsd-version
11.0-RELEASE-p1

Code: 
$ sudo touch /etc/make.conf
$ sudo nano /etc/make.conf
$ cat /etc/make.conf
DEFAULT_VERSIONS=pgsql=9.6

Code: 
$ sudo pkg install pgadmin3
Password:
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:
   postgresql96-server-9.6.0_1
   postgresql96-client-9.6.0

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.

fbsdgo said:
Code: 
$ cat /etc/make.conf DEFAULT_VERSIONS=pgsql=9.6
Click to expand...
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?

Code: 
$ sudo freebsd-update fetch
Password:
Looking up update.FreeBSD.org mirrors... none found.
Fetching metadata signature for 11.0-RELEASE from update.FreeBSD.org... 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.

Code: 
$ pwd
/usr/ports/databases/pgadmin3
$ sudo make install clean
Password:
===>  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

Stop.
make: stopped in /usr/ports/databases/pgadmin3
 
Last edited:
You must log in or register to reply here.
Back
Top