/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 vote319 views2 answers
How to unrar multiple files at once linux
Shell/Bash
12 votes404 views3 answers
How to pip install on command prompt
Shell/Bash
1 vote354 views1 answer
Install xdotool ubuntu
Shell/Bash
0 vote320 views1 answer
Wordpress mit ssh installieren
Shell/Bash
2 votes333 views2 answers
Launch sublime from terminal
Shell/Bash
0 vote362 views1 answer
Restart fstab ununtu
Shell/Bash
0 vote314 views1 answer
Start a local SMTP debugging server in linux
Shell/Bash
0 vote326 views1 answer
Pip install win32api
Shell/Bash
-2 votes334 views2 answers
Github how to add ssh key
Shell/Bash
0 vote342 views1 answer
2FA git commands
Shell/Bash

Share