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 vote350 views2 answers
Download python-dev
Shell/Bash
0 vote352 views1 answer
Laravel sqlite .env
Shell/Bash
0 vote362 views1 answer
Telnet in shell script
Shell/Bash
0 vote379 views1 answer
W: GPG error: http://packages.ros.org/ros/ubuntu xenial InRelease: The following signatures were invalid: KEYEXPIRED 1622248854
Shell/Bash
0 vote348 views1 answer
Linux check speed of file growth
Shell/Bash
0 vote347 views1 answer
Best code editors 2022
Shell/Bash
0 vote324 views1 answer
Powershell get all computers in ou
Shell/Bash
0 vote382 views1 answer
Backup pihole settings
Shell/Bash
0 vote379 views1 answer
Inquiring battery power level linux fedora
Shell/Bash
12 votes370 views5 answers
Adding path in mac
Shell/Bash