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 vote342 views1 answer
Manueldeveloper github
Shell/Bash
9 votes373 views2 answers
Windows 10 copy ssh key to server
Shell/Bash
75 votes348 views6 answers
Docker install
Shell/Bash
0 vote339 views1 answer
Git clone different ssh key
Shell/Bash
3 votes388 views3 answers
Ffmpeg download hls to mp4 with token
Shell/Bash
0 vote300 views1 answer
Create crt and key openssl
Shell/Bash
0 vote308 views1 answer
502 bad gateway nginx gunicorn flask
Shell/Bash
0 vote332 views1 answer
Move to folder in command line windows
Shell/Bash
1 vote361 views1 answer
How to send notification in linux
Shell/Bash
0 vote314 views1 answer
Julia arch linux
Shell/Bash