/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 vote117 views1 answer
How to ignore folder in gitignore duplicate
Shell/Bash
1 vote126 views1 answer
Tr in shell script
Shell/Bash
0 vote124 views1 answer
Command to fix frozen shell
Shell/Bash
0 vote116 views1 answer
How to install bwa in ubuntu
Shell/Bash
2 votes120 views2 answers
Sqlmap enumerate tables in databases
Shell/Bash
1 vote143 views2 answers
Powershell variable to string
Shell/Bash
0 vote112 views1 answer
Npm -g yarn
Shell/Bash
3 votes115 views1 answer
Timezone brasil postgresql
Shell/Bash
-2 votes138 views1 answer
What my ip mac
Shell/Bash
1 vote120 views1 answer
Ubuntu photo viewer zoom in shortcut
Shell/Bash

Share