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

1 vote260 views1 answer
Failed to execute child process “python” (No such file or directory)
Shell/Bash
0 vote275 views1 answer
NGINX systemd service file
Shell/Bash
0 vote278 views1 answer
Sed from match to end of file
Shell/Bash
1 vote270 views1 answer
Grep get count of matches
Shell/Bash
16 votes267 views3 answers
Linux replace string in all files
Shell/Bash
0 vote289 views1 answer
Remove mariadb
Shell/Bash
1 vote264 views1 answer
Move files one level up linux
Shell/Bash
0 vote263 views1 answer
Remove microsoft edge from ubuntu
Shell/Bash
0 vote212 views1 answer
Linux dns resolve
Shell/Bash
1 vote309 views1 answer
Windows how to access wsl from explorer
Shell/Bash