Delete
Do Record
Setting
Add New Item
Menu List
| Title | Content Type | Order | Action | ||||||
|---|---|---|---|---|---|---|---|---|---|
| {{kb_content.name}} {{kb_content.name}} | {{setValue(content_types, kb_content.content_type)}} | {{kb_content.sort_order}} | Preview Edit Edit Content | ||||||
| {{kb_content.name}} | {{setValue(content_types, kb_content.content_type)}} | {{kb_content.sort_order}} | Preview Edit Edit Content | ||||||
| No record | |||||||||
Status: published
Programming, Software and application
2022-01-09 18:30:29
Installing pgAdmin4
1445
You are new to Linux and switch to the Linux Operating System, this is a tutorial for you. This will help you to start your journey in the Linux system because when you perform daily operations in this system, you will not stack on it.
After installing the OS, we need some basic applications to do our daily operation such as browser, zoom, skype. If we are a developer then we need some development tools like Node.Js and NPM, PHP, phpMyAdmin, MySQL, Apache, Tomcat, DBreaver etc. This tutorial will cover all of this.
Important thing is when you enable the installation of those applications, you will learn many things regarding Linux OS.
এই কোর্সে যা থাকছে
৩টি বিষয়
৮০টি লাইভ ক্লাস
pgAdmin 4 is a free open source graphical management tool for PostgreSQL and derivative relational databases such as EnterpriseDB's EDB Advanced Server.
pgAdmin4 is not available in the Ubuntu repositories. We need to install it from the pgAdmin4 APT repository. Start by setting up the repository. Add the public key for the repository and create the repository configuration file.
curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo apt-key add sudo sh -c 'echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt update'
Then install pgAdmin4,
sudo apt install pgadmin4
The above command will install numerous required packages including Apache2 webserver to serve the pgadmin4-web application in web mode.
Once the installation is complete, run the web setup script which ships with the pgdmin4 binary package, to configure the system to run in web mode. You will be prompted to create a pgAdmin4 login email and password as shown in the screenshot below.
This script will configure Apache2 to serve the pgAdmin4 web application which involves enabling the WSGI module and configuring the pgAdmin application to mount at pgadmin4 on the webserver so you can access it at:
It also restarts the Apache2 service to apply the recent changes.
Remember to replace admin@tecmint.lan with your email address and set a strong secure password as well:
$ sudo /usr/pgadmin4/bin/setup-web.sh
Give email and password and continue pressing Y.
Accessing pgAdmin4 Web Interface
To access the pgAdmin4 web application interface, open a web browser, and use the following address to navigate:
http://SERVER_IP/pgadmin4
Once the login page loads, enter the email address and password you created in the previous section while configuring the pgAdmin4 to run in web mode.