/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

1 vote143 views1 answer
How to make copy of branch in git
Shell/Bash
0 vote136 views1 answer
Clone repo with large size using git bash
Shell/Bash
4 votes155 views4 answers
Git stash pop specific
Shell/Bash
0 vote137 views1 answer
Git take ours
Shell/Bash
4 votes134 views1 answer
Linux move all files up a directory
Shell/Bash
0 vote218 views1 answer
Check bluetooth radio status bash
Shell/Bash
1 vote160 views1 answer
Linux create executable
Shell/Bash
0 vote140 views1 answer
Git repo add
Shell/Bash
0 vote162 views1 answer
Ssh into vagrant
Shell/Bash
46 votes156 views6 answers
Terminal unzip
Shell/Bash

Share