Search This Blog

Tuesday, June 2, 2020

Postgresql 12 with PGAdmin4 Installation in Linux Ubuntu 16 18 20


 Install Postgresql 12

1. sudo apt-get install postgresql-12

2.  sudo -u postgres psql postgres

3. \password postgres

         Enter new and confirm password : xxxxx



Install PGAdmin 4


1. apt clean

2. apt autoclean

3. sudo apt update

4. sudo apt install pgadmin4 pgadmin4-apache2
                   #. username : postgres@localhost
                   #. pwd : xxxxx

5. sudo ufw allow http

6. sudo ufw allow https


7. In Browser : http://localhost/pgadmin4/

8. 4th point credentials

9. Type again http://localhost/pgadmin4/browser/ if you see apache2 default page.

10. Connect with new server -> Postgres user/pwd.



No comments:

Hit Counter


View My Stats