/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 vote200 views2 answers
Install waitress
Shell/Bash
-4 votes215 views2 answers
Linux shell system commands
Shell/Bash
0 vote213 views1 answer
Install vue native globally
Shell/Bash
16 votes224 views3 answers
Git restore to remote
Shell/Bash
0 vote224 views1 answer
Catch grep cat last first lines of a file linux
Shell/Bash
0 vote221 views1 answer
How to show which kerne version is intalled on the system linux
Shell/Bash
4 votes254 views2 answers
Firebase deploy hosting only command
Shell/Bash
0 vote238 views1 answer
Powershell run bat file
Shell/Bash
22 votes207 views6 answers
Git untrack file
Shell/Bash
1 vote216 views1 answer
"crontab" change dynamically shell
Shell/Bash

Share