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 vote188 views1 answer
Bash print file permissions
Shell/Bash
-1 vote266 views1 answer
Install pip dockerfile
Shell/Bash
21 votes206 views1 answer
Add user to sudoers debian
Shell/Bash
1 vote189 views1 answer
How to find address git is pushed
Shell/Bash
0 vote274 views1 answer
Ssh change pasword to key file
Shell/Bash
1 vote182 views1 answer
Ufw config file location ubuntu
Shell/Bash
0 vote148 views1 answer
Docker run start directory
Shell/Bash
2 votes192 views3 answers
Restart crontab
Shell/Bash
46 votes192 views6 answers
Ssh copy from remote to local
Shell/Bash
0 vote164 views1 answer
Login authentication in android using volley github
Shell/Bash