/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

2 votes191 views2 answers
How to set gopath/bin linux
Shell/Bash
1 vote177 views1 answer
Cannot find module '@angular-devkit/build-angular/package.json' Docker
Shell/Bash
0 vote188 views1 answer
How to install p12 certificate in ubuntu
Shell/Bash
16 votes173 views1 answer
Bash sleep milliseconds
Shell/Bash
2 votes181 views2 answers
Preload for ubuntu
Shell/Bash
0 vote502 views1 answer
How to silence operation not permitted
Shell/Bash
0 vote173 views1 answer
Crontab only working days
Shell/Bash
0 vote187 views2 answers
Apt-get install ping?trackid=sp-006
Shell/Bash
0 vote173 views1 answer
Install opencl library
Shell/Bash
0 vote180 views1 answer
Apache2 ubuntu code exited
Shell/Bash

Share