/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

11 votes158 views1 answer
Git same as origin master
Shell/Bash
1 vote162 views2 answers
Install wordpress linux
Shell/Bash
1 vote223 views1 answer
Uninstall lightdm
Shell/Bash
11 votes167 views1 answer
Uninstall node js and npm ubuntu
Shell/Bash
0 vote160 views1 answer
Using timeshift to make system snapshot like in windows & mac
Shell/Bash
11 votes124 views2 answers
Terraform
Shell/Bash
2 votes148 views1 answer
Powershell get input from user
Shell/Bash
1 vote145 views2 answers
Treating warnings as errors because process.env.CI = true. github
Shell/Bash
0 vote141 views2 answers
Install anaconda on linux
Shell/Bash
1 vote144 views1 answer
Force to kill any process port ubuntu
Shell/Bash

Share