/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

13 votes103 views5 answers
Uninstall anaconda in ubuntu
Shell/Bash
-2 votes93 views2 answers
Ubuntu check ssh
Shell/Bash
0 vote117 views1 answer
Remove files from hadoop (hdfs)
Shell/Bash
1 vote113 views1 answer
Install sox in ubuntu
Shell/Bash
0 vote141 views1 answer
Sftp local directory
Shell/Bash
0 vote61 views0 answer
Shell/Bash
6 votes115 views2 answers
Install flutter mac terminal
Shell/Bash
1 vote100 views2 answers
Git Automatic merge failed; fix conflicts and then commit the result
Shell/Bash
2 votes130 views2 answers
Git lost changes after reset --keep
Shell/Bash
-1 vote101 views1 answer
Graphviz windows install
Shell/Bash

Share