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:
Post a Comment