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

3 votes298 views1 answer
How to clean cache in npn
Shell/Bash
0 vote314 views1 answer
Kubectl neat not found
Shell/Bash
0 vote306 views1 answer
No linux como dar permição ao .git no htdocs
Shell/Bash
0 vote309 views1 answer
Linux mount lvm
Shell/Bash
4 votes336 views3 answers
Git log by author
Shell/Bash
0 vote313 views2 answers
Move files command line windows
Shell/Bash
0 vote320 views1 answer
The lsb_release command ubuntu faq
Shell/Bash
5 votes295 views3 answers
Restart bashrc
Shell/Bash
1 vote316 views1 answer
Failed to push some refs to repository
Shell/Bash
6 votes322 views1 answer
Uninstall openshot linux
Shell/Bash