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 vote104 views1 answer
Run.sh minecraft
Shell/Bash
17 votes123 views5 answers
Remove directory from git
Shell/Bash
0 vote115 views1 answer
Centos selinux set permissive
Shell/Bash
0 vote102 views3 answers
Thelinuxterminal.com grep command
Shell/Bash
0 vote109 views1 answer
Linux history select command
Shell/Bash
0 vote124 views1 answer
Error: <class 'xmlrpclib.Fault'>, <Fault 6: 'SHUTDOWN_STATE'>: file: /usr/lib/python2.7/xmlrpclib.py line: 800
Shell/Bash
24 votes107 views2 answers
Setup commandline vscode in mac
Shell/Bash
0 vote116 views1 answer
Rails reset gemfile.lock
Shell/Bash
0 vote147 views1 answer
You are running create-react-app
Shell/Bash
9 votes99 views2 answers
Task manager linux
Shell/Bash