/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 vote112 views1 answer
Install whitenoise
Shell/Bash
0 vote109 views1 answer
Why double tapping icon doesnt minimize in ubuntu
Shell/Bash
0 vote105 views3 answers
Venv deactivate
Shell/Bash
0 vote166 views1 answer
GitHubDesktop-linux-2.5.4-linux1.deb
Shell/Bash
1 vote110 views1 answer
How to figure out ubuntu partition
Shell/Bash
0 vote97 views1 answer
Cpanel fix home directory permissions
Shell/Bash
0 vote106 views3 answers
Git merge with message
Shell/Bash
2 votes99 views3 answers
Tail last 100 lines
Shell/Bash
0 vote108 views6 answers
Libgthread-2.0.so.0: cannot open shared object file: No such file or directory
Shell/Bash
3 votes98 views2 answers
Get current working directory powershell
Shell/Bash

Share