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

1 vote218 views1 answer
Centos zoom
Shell/Bash
5 votes267 views2 answers
Kill port in kali linux
Shell/Bash
0 vote212 views1 answer
Initramfs ubuntu 20.04
Shell/Bash
1 vote244 views1 answer
Your connection attempt failed for user 'root' to the MySQL server at localhost:3306: An AppArmor policy prevents this sender from sending this message to this recipient
Shell/Bash
2 votes238 views1 answer
Git lines per user
Shell/Bash
0 vote168 views1 answer
Mac terminal hide username from window
Shell/Bash
1 vote195 views1 answer
How to tell ping to exit after a specified number of ECHO_REQUEST packets
Shell/Bash
0 vote219 views1 answer
Learn how to use bash (variables)
Shell/Bash
0 vote222 views1 answer
Scp HostKeyVerification=false
Shell/Bash
1 vote368 views1 answer
No such module 'Capacitor'
Shell/Bash