/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 vote309 views1 answer
Cmder find parameter formate not correct
Shell/Bash
63 votes323 views6 answers
Undo most recent commit
Shell/Bash
0 vote322 views1 answer
Install rosserial_python
Shell/Bash
0 vote309 views1 answer
Npm install compression
Shell/Bash
3 votes332 views2 answers
View path powershell
Shell/Bash
0 vote315 views2 answers
Permission denied (publickey,keyboard-interactive).
Shell/Bash
0 vote304 views1 answer
Awk sum column
Shell/Bash
0 vote306 views1 answer
How to set global github username and password in git
Shell/Bash
4 votes344 views1 answer
Install docker on manjaro linux
Shell/Bash
1 vote308 views2 answers
Kivy install ubuntu
Shell/Bash

Share