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

2 votes182 views2 answers
Xampp apache not starting
Shell/Bash
2 votes199 views1 answer
Ubuntu install clamav
Shell/Bash
0 vote195 views2 answers
Github.com developer
Shell/Bash
0 vote163 views1 answer
User no login centos
Shell/Bash
0 vote226 views1 answer
Why jupyter notebook suggestions not showing after upgrade
Shell/Bash
0 vote178 views1 answer
Instal kdenlive
Shell/Bash
20 votes177 views1 answer
Styled-components
Shell/Bash
0 vote181 views1 answer
Can't git restore error: path is unmerged
Shell/Bash
134 votes264 views6 answers
Npm update package
Shell/Bash
5 votes228 views1 answer
Git commit current changes to existing branch
Shell/Bash