/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 vote263 views1 answer
How to git merge with specific commit
Shell/Bash
0 vote268 views1 answer
Linux terminal color change
Shell/Bash
2 votes252 views2 answers
Install minikube
Shell/Bash
2 votes267 views1 answer
Change owner of all the files from a directory linux
Shell/Bash
0 vote249 views1 answer
Regex last match
Shell/Bash
2 votes240 views1 answer
Restart a pod kubernetes
Shell/Bash
16 votes251 views1 answer
Angular install firebase tools
Shell/Bash
0 vote238 views1 answer
Expo cli not installing
Shell/Bash
1 vote283 views3 answers
/usr/share/npm/lib/utils/unsupported.js
Shell/Bash
3 votes271 views3 answers
Obs
Shell/Bash

Share