/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

-1 vote160 views1 answer
Change date and time in kali linux 2021
Shell/Bash
1 vote129 views1 answer
Angular add modulee
Shell/Bash
2 votes122 views1 answer
Store environment variables firebase functions
Shell/Bash
0 vote133 views2 answers
How to convert back to JSON in powershell
Shell/Bash
0 vote128 views1 answer
Git log filter merge commits
Shell/Bash
8 votes103 views4 answers
Curl download file
Shell/Bash
0 vote143 views1 answer
Suse linux update
Shell/Bash
0 vote153 views1 answer
Use -i
Shell/Bash
0 vote135 views1 answer
Kubernetes get crd and their namespaces
Shell/Bash
0 vote138 views1 answer
Install crontab in linux
Shell/Bash

Share