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 vote123 views1 answer
Not a git repository after clone
Shell/Bash
0 vote115 views1 answer
Install rhythmbox
Shell/Bash
0 vote157 views1 answer
Add a project in rancher
Shell/Bash
0 vote127 views1 answer
How to edit etc/hosts linux error readonly
Shell/Bash
20 votes101 views1 answer
Delete already stashed files git
Shell/Bash
0 vote120 views1 answer
Git change author multiple commits
Shell/Bash
0 vote138 views1 answer
Change permission to connect your SSH instance mac
Shell/Bash
0 vote121 views1 answer
TkPDFViewer install
Shell/Bash
26 votes112 views3 answers
Webpack uninstall npm
Shell/Bash
0 vote123 views1 answer
Cmder find file
Shell/Bash