/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 vote329 views1 answer
Oh zsh
Shell/Bash
39 votes377 views6 answers
Cors npm
Shell/Bash
1 vote343 views2 answers
Docker machine ip
Shell/Bash
0 vote362 views1 answer
How to chop large sequences in linux
Shell/Bash
34 votes350 views6 answers
Ubuntu install pip
Shell/Bash
0 vote383 views1 answer
Linux silence stderr
Shell/Bash
29 votes362 views6 answers
Linux install nvm
Shell/Bash
0 vote357 views1 answer
How to install brave browser on manjaro
Shell/Bash
3 votes333 views1 answer
Module build failed: Error: Node Sass does not yet support your current environment: OS X 64-bit with Unsupported runtime (79)
Shell/Bash
0 vote376 views1 answer
Show output after a keyword in shell script in a file
Shell/Bash

Share