How to install pgAdmin4 on FreeBSD 12

The
You can download this article in PDF format to support us through the following link.

Download the guide in PDF format

turn off
The

The
The

pgAdmin is the leading open source feature-rich PostgreSQL management and development platform that can run on Linux, Unix, Mac OS X and Windows. It provides a powerful GUI to simplify database management and operation.

pgAdmin allows you to manage PostgreSQL 9.2 and higher. At the time of writing, the latest version of pgAdmin is v4 Migrating from Bootstrap 3 to Bootstrap 4.

Set prerequisites

As a prerequisite, you need to have:

FreeBSD server
Installed PostgreSQL server
User account with sudo privileges

Step 1: Install PostgreSQL database server

For the installation of PostgreSQL database server, please refer to our previous guide:

How to install PostgreSQL 11 on FreeBSD 12

Step 2: Update FreeBSD system

In my setup, I installed pgAdmin on the same server running PostgreSQL. But you can choose to set it on other servers.

First update the FreeBSD database database.

freebsd-update fetchfreebsd-update install

Step 3: Install Python pip and Virtualenv

pip is required to install Python packages. Follow the guide below to install it on your FreeBSD server.

How to install pip Python package manager on FreeBSD 12

Once pip is installed, please install the virtualenv package.

sudo pkg install py36-virtualenv

If you are using Python 2.7, please run:

sudo pkg install py27-virtualenv

Step 4: Install the pgAdmin suite

Create a virtual environment for pgAdmin4 by running the following command:

$ virtualenv-3.6 pgadmin4 Using base prefix '/usr/local' New python executable in /home/vagrant/pgadmin4/bin/python3.6 Also creating executable in /home/vagrant/pgadmin4/bin/python Installing setuptools, pip, wheel…done.

For Python 2.7, it should be

virtualenv pgadmin4

Activate the created virtual environment:

source pgadmin4/bin/activate

If it fails, use:

source pgadmin4/bin/activate.csh

Install Python dependencies for pgAdmin:

pip install pyopenssl cryptography pyasn1  ndg-httpsclient

Then install the standard Python bindings to the SQLite3 library. For python 3.6, run:

sudo pkg install py36-sqlite3

For Python 2.7, use:

sudo pkg install py27-sqlite3

Before downloading, please check the latest version of pgAdmin4. After getting the latest version of the path, please use pip command.

pip install https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.1/pip/pgadmin4-4.1-py2.py3-none-any.whl

Since many dependencies are installed, this installation may take some time, so please be patient.

Step 5: Configure and run pgAdmin 4

After installation, a configuration file should be created for pgAdmin 4.

cp ./pgadmin4/lib/python3.6/site-packages/pgadmin4/config.py ./pgadmin4/lib/python3.6/site-packages/pgadmin4/config_local.py

For Python 2.7, replace python3.6 versus python2.7

Change the listening address of the default server to 0.0.0.0

vim ./pgadmin4/lib/python3.6/site-packages/pgadmin4/config_local.py

This is the line 138

DEFAULT_SERVER = '0.0.0.0'

The default listening port is 5050 But you can change it to the desired port.

The default port on which the app server will listen if not set in the environment by the runtimeDEFAULT_SERVER_PORT = 5050

Use the following command to run pgAdmin.

$ sudo python ./pgadmin4/lib/python3.6/site-packages/pgadmin4/pgAdmin4.pyNOTE: Configuring authentication for SERVER mode.Enter the email address and password to use for the initial pgAdmin user account:Email address: [email protected]Password: Retype password: pgAdmin 4 - Application InitialisationStarting pgAdmin 4. Please navigate to http://0.0.0.0:5050 in your browser.

The first run will require you to enter email address with password Used for pgAdmin user account.

Step 6: Access the pgAdmin web interface

Now that we have installed and running pgAdmin4, you can access the URL by “http: // your server_ip: 5050“.

Log in using the created user email address and password. After logging in, you need to connect to the PostgreSQL server.

Enter the server connection name and group.

Down “Connect” Labels provide access details-database host, database user and password.

Save the settings to activate your connection.

Now you can use pgAdmin for PostgreSQL database management tasks.

If you are a MariaDB user, please check: How to install MariaDB 10.3 on FreeBSD 12

How to install PHP 7.3 on FreeBSD 12