/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 vote144 views1 answer
Curl output to stdout
Shell/Bash
0 vote124 views2 answers
Sudo apt install xfce4 xfce4-goodies -y
Shell/Bash
4 votes129 views3 answers
Git pull from commit
Shell/Bash
0 vote153 views1 answer
How to install drawing in ubuntu
Shell/Bash
0 vote123 views1 answer
Connect amazon lightsail mac
Shell/Bash
1 vote120 views2 answers
Bash dynamic variable name
Shell/Bash
2 votes158 views1 answer
Bash how to pass shell variables to awk
Shell/Bash
2 votes161 views3 answers
Install serverless
Shell/Bash
1 vote122 views1 answer
Grep docker logs
Shell/Bash
0 vote151 views1 answer
Brew installs slack homebew
Shell/Bash

Share