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 vote135 views1 answer
How to install downloaded packages in ubuntu
Shell/Bash
9 votes145 views5 answers
Create a ssh key
Shell/Bash
0 vote143 views1 answer
Install java 16 ubuntu
Shell/Bash
0 vote252 views1 answer
Sudo apt uninstall docker compose
Shell/Bash
0 vote171 views1 answer
Update nodejs centos
Shell/Bash
0 vote161 views1 answer
Install csfml on linux
Shell/Bash
15 votes163 views6 answers
Update vs code in ubuntu
Shell/Bash
1 vote140 views1 answer
Split and get last
Shell/Bash
0 vote164 views2 answers
Php 7.4 raspberry pi
Shell/Bash
6 votes137 views2 answers
List of running port ubuntu
Shell/Bash