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 vote312 views1 answer
Restart rstudio
Shell/Bash
0 vote318 views1 answer
How to uninstall a package installed using homebrew
Shell/Bash
88 votes266 views6 answers
Delete all container and images docker
Shell/Bash
61 votes279 views6 answers
Install yarn windows
Shell/Bash
0 vote264 views2 answers
Linux install slic3r
Shell/Bash
1 vote315 views1 answer
Vi bulk select and replace
Shell/Bash
0 vote288 views1 answer
Pip install osgeo
Shell/Bash
64 votes274 views6 answers
Yarn install
Shell/Bash
12 votes283 views2 answers
Yarn clear cache
Shell/Bash
1 vote272 views2 answers
Ubuntu error: EACCES: permission denied, symlink '../lib/node_modules/yarn/bin/yarn.js' -> '/usr/local/bin/yarn'
Shell/Bash