/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 vote335 views1 answer
Committing on github
Shell/Bash
6 votes330 views4 answers
Gitlab push
Shell/Bash
3 votes332 views2 answers
Git Code Push
Shell/Bash
0 vote300 views1 answer
Expo install in ubuntu
Shell/Bash
3 votes303 views2 answers
Failed to load module canberra-gtk-module
Shell/Bash
0 vote318 views1 answer
› Error: Missing required flag: › -a, --app APP parent app used by review apps
Shell/Bash
0 vote311 views1 answer
Pick yarn version
Shell/Bash
1 vote332 views1 answer
Failed to start cron.service: Unit not found. in centos7
Shell/Bash
4 votes319 views1 answer
How to reset git branch to a certain commit.
Shell/Bash
1 vote333 views1 answer
Grep get count of matches
Shell/Bash

Share