Video Tutorial- https://youtu.be/mTC1sguOoWs
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
phpPgAdmin is a web-based administration tool for PostgreSQL. It is perfect for PostgreSQL DBAs, newbies, and hosting services.
Offcial Website: http://phppgadmin.sourceforge.net/doku.php
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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
User - postgres | password - yourpassword
leafpad /etc/apache2/conf-available/phppgadmin.conf &>/dev/null
#Require local
Require all granted
leafpad /etc/phppgadmin/config.inc.php &>/dev/null
$conf['extra_login_security'] = false;
systemctl restart postgresql apache2 ; netstat -plntu
http://www.yourdomain.com/phppgadmin/
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment