/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

3 votes322 views2 answers
Uninstall webpack globally
Shell/Bash
2 votes293 views1 answer
React quill
Shell/Bash
4 votes333 views3 answers
Mac run a shell script
Shell/Bash
0 vote352 views1 answer
Bash linux scripting laguage
Shell/Bash
-1 vote342 views5 answers
Install youtube-dl ubuntu
Shell/Bash
0 vote314 views1 answer
Install composer wsl
Shell/Bash
42 votes314 views4 answers
Remove git repository
Shell/Bash
1 vote308 views1 answer
Vscode disable powershell integrated console
Shell/Bash
0 vote332 views1 answer
Set mdp user ubuntu
Shell/Bash
1 vote329 views1 answer
Restart wpa raspberrypi
Shell/Bash

Share