/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 vote263 views6 answers
GREPPER ANSWER
Shell/Bash
0 vote279 views1 answer
Ubuntu screen remove
Shell/Bash
2 votes315 views1 answer
How to run makefile in windows
Shell/Bash
3 votes271 views2 answers
Merge master with main
Shell/Bash
1 vote273 views4 answers
How to install typescript on ubuntu
Shell/Bash
1 vote317 views2 answers
Zsh: permission denied
Shell/Bash
63 votes282 views3 answers
Ubuntu see port usage
Shell/Bash
0 vote295 views4 answers
Replace a newline using sed linux bash
Shell/Bash
0 vote281 views1 answer
Bash make folders according to a list
Shell/Bash
1 vote285 views2 answers
Undo git file changes
Shell/Bash

Share