Search This Blog

Showing posts with label pgadmin3. Show all posts
Showing posts with label pgadmin3. Show all posts

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.



Hit Counter


View My Stats