/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 vote327 views1 answer
How to install gnu lib tool
Shell/Bash
1 vote347 views2 answers
How to copy git repository to another repository
Shell/Bash
0 vote320 views1 answer
Vscode "code ." shortcut for Mac
Shell/Bash
0 vote383 views1 answer
Logstash automatic config reload
Shell/Bash
1 vote351 views1 answer
Unexpected value 'RoundProgressModule in
Shell/Bash
0 vote317 views1 answer
Linux vga wake up screen
Shell/Bash
0 vote347 views1 answer
Install sdl msys2
Shell/Bash
0 vote319 views1 answer
How to remove a directory recursively ubuntu
Shell/Bash
0 vote337 views1 answer
How to add program to command line linux
Shell/Bash
1 vote334 views3 answers
LinuxBrew
Shell/Bash

Share