/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

15 votes191 views2 answers
Show env in bash
Shell/Bash
1 vote174 views2 answers
Ufw see open ports
Shell/Bash
0 vote148 views1 answer
Cask command not found
Shell/Bash
1 vote214 views1 answer
Vim replace last match on every line
Shell/Bash
3 votes184 views2 answers
Use a specific version of node
Shell/Bash
0 vote189 views1 answer
Install Discord Together
Shell/Bash
0 vote193 views1 answer
Ssh tunel
Shell/Bash
4 votes185 views3 answers
Ds_store gitignore
Shell/Bash
1 vote207 views1 answer
Git how to commit changes to a new branch
Shell/Bash
0 vote196 views1 answer
How to rename origin in git
Shell/Bash

Share