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 vote132 views1 answer
Activar htaccess en apache
Shell/Bash
0 vote136 views1 answer
Change crontab editor
Shell/Bash
0 vote118 views1 answer
See output of a running processes linux
Shell/Bash
3 votes132 views1 answer
How to check if ros is installed
Shell/Bash
2 votes125 views1 answer
>> bash
Shell/Bash
0 vote143 views1 answer
Mover linux ssh
Shell/Bash
6 votes124 views3 answers
Take screenshot linux
Shell/Bash
0 vote135 views1 answer
Offline heic to jpg converter on linux
Shell/Bash
0 vote134 views1 answer
How to use yes command in linux
Shell/Bash
0 vote143 views1 answer
Install software manager linux kali
Shell/Bash