All tech notesInstall PostgreSQL in Ubuntu 20.04
Installing PostgreSQL in Ubuntu 20.04 and create the user and password to connect remotely.
Published June 10, 2021
Install PostgreSQL in Ubuntu 20.04
update system
sudo apt-get update
install postgreSQL
sudo apt install postgresql postgresql-contrib
open postgreSQL
sudo -i -u postgres psql
close
\q
create new user
sudo -u postgres createuser --interactive
create new database
sudo -u postgres createdb sammy
add the new user in ubuntu 20.04
sudo adduser sammy
change user password
sudo -u postgres psql
ALTER USER samy PASSWORD 'myPassword';
\q
