Postgres database create

Create postgres database

sudo -u postgres psql
postgres=# create database mydb;
postgres=# create user myuser with encrypted password 'mypass';
postgres=# grant all privileges on database mydb to myuser;

Source: medium.com

Create database postgres

createdb -h localhost -p 5432 -U postgres testdb
password ******

Source: tutorialspoint.com

Similar codes

0 vote205 views1 answer
Decodificador h.264 necessario para reproduzir ubuntu 20
Shell/Bash
1 vote193 views2 answers
Upload directory ssh to remote
Shell/Bash
1 vote197 views1 answer
Zsh: command not found: pg_restore docker
Shell/Bash
3 votes188 views1 answer
Bash delete env variable
Shell/Bash
0 vote192 views1 answer
Vue-session
Shell/Bash
0 vote191 views2 answers
Powershell command to get cpu info
Shell/Bash
0 vote200 views1 answer
Edit grub file
Shell/Bash
1 vote219 views1 answer
Jupyter sagemath kernel
Shell/Bash
1 vote196 views2 answers
Dns_probe_finished_nxdomain linux ubuntu
Shell/Bash
181 votes747 views6 answers
Make a new branch git
Shell/Bash