How To Install PostgreSQL on Ubuntu 20.04

Описание

? Buy my awesome golang course - https://akhilsharmatech.gumroad.com/l/tgaibot

? Join my FREE discord community to learn new technologies - https://discord.gg/m5zBzzd2

? Follow me on twitter - https://twitter.com/AkhilAiri

My New Udemy Course, please enroll - https://www.udemy.com/course/build-3-simple-golang-projects/

In this video we will see how to install PostgreSQL on Ubuntu 20.04

1. sudo apt update
2. sudo apt install postgresql postgresql-contrib
3. sudo -i -u postgres
4. psql
5. \q (to be run on postgres command line)
6. exit
7. sudo -u postgres psql
8. \q
9. createuser --interactive
10. sudo -u postgres createuser --interactive
11. createdb sammy
12. sudo -u postgres createdb sammy
13. sudo adduser sammy
14. sudo -i -u sammy
psql
15. sudo -u sammy psql
16. psql -d postgres
17. \conninfo