/Shell/Bash/Postgres create admin user with password

Postgres create admin user with password

Create new user in postgres

CREATE USER visualscrapy WITH PASSWORD '123456';
# it will create the new user in postgres

1

Postgres create admin user with password

sudo -u postgres createuser -s -i -d -r -l -w <<username>>
sudo -u postgres psql -c "ALTER ROLE <<username>> WITH PASSWORD '<<password>>';"

0

Source: stackoverflow.com

Similar codes

0 vote296 views1 answer
Ssh pem
Shell/Bash
0 vote328 views1 answer
Bin/sh sam: not found
Shell/Bash
0 vote310 views1 answer
Netdata kickstart
Shell/Bash
-1 vote258 views1 answer
Craft bukkit
Shell/Bash
3 votes297 views3 answers
How to convert ui to py pyqt5
Shell/Bash
0 vote308 views2 answers
How many ppi is 4k
Shell/Bash
1 vote290 views1 answer
Update pycocotools
Shell/Bash
0 vote295 views2 answers
Cron crontab
Shell/Bash
0 vote280 views1 answer
Cat a file in powershell
Shell/Bash
95 votes315 views5 answers
Angular install
Shell/Bash

Share