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

30 votes198 views3 answers
Heroku logs
Shell/Bash
1 vote117 views1 answer
Git list origin branches
Shell/Bash
8 votes135 views1 answer
Access windows files from windows ubuntu
Shell/Bash
0 vote97 views0 answer
Shell/Bash
0 vote143 views1 answer
How to completely remove blender from ubuntu
Shell/Bash
12 votes138 views3 answers
Find text in all files linux
Shell/Bash
0 vote138 views1 answer
Bash create file with content
Shell/Bash
0 vote99 views1 answer
Where to find github invites
Shell/Bash
0 vote152 views2 answers
Mongodb container mongodump openshift
Shell/Bash
7 votes138 views1 answer
Speedtest python oneliner
Shell/Bash