Thursday, September 12, 2019

How To Install and Configure pgAdmin4 on Ubuntu 18.04


Video Tutorial -https://youtu.be/2n9tt6lvWkA

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

pgAdmin is a web-based interface for management of PostgreSQL database instances.
Offcial Website: https://www.pgadmin.org/           
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Our Server Specification-    
Os:Ubuntu 18.04 LTS Bionic Beaver 64Bit   |IP address- 192.168.1.50  | Hostname :www.yourdomain.com
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
lsb_release -cd ; hostname ; hostname -I ; whoami ; getconf LONG_BIT ; apt install -y build-essential software-properties-common curl gdebi net-tools wget curl sqlite3 dirmngr nano lsb-release apt-transport-https leafpad git sudo unzip socat bash-completion checkinstall imagemagick openssl

apt -y install postgresql postgresql-contrib phppgadmin apache2
sudo -u postgres psql postgres
\password postgres

wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main" >> /etc/apt/sources.list.d/pgdg.list'
apt-get update ; apt install pgadmin4 pgadmin4-apache2 -y
http://www.yourdomain.com/pgadmin4

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

No comments:

Post a Comment