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 vote291 views1 answer
Delete cash on ubuntu
Shell/Bash
0 vote300 views1 answer
Set multiple git username and password
Shell/Bash
0 vote281 views1 answer
Pass \l to psql from linux
Shell/Bash
0 vote304 views1 answer
Linux create user with expiration
Shell/Bash
0 vote253 views2 answers
How to accept invitation on github private repository
Shell/Bash
14 votes280 views4 answers
How to find process running on port in ubuntu
Shell/Bash
0 vote294 views1 answer
Sigin failed for rsa github signing
Shell/Bash
0 vote295 views1 answer
Creating splash screen for nativescript
Shell/Bash
0 vote323 views1 answer
Ascii to binary perl
Shell/Bash
0 vote292 views1 answer
Install "repo"
Shell/Bash