/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 vote125 views1 answer
Create new workflow branch
Shell/Bash
1 vote140 views1 answer
Grep find and show lines after
Shell/Bash
0 vote133 views1 answer
Xargs curl url
Shell/Bash
0 vote103 views1 answer
Install snap on debian
Shell/Bash
0 vote143 views1 answer
Git add -p
Shell/Bash
0 vote120 views1 answer
How to install zsh using brew
Shell/Bash
0 vote126 views1 answer
Bc add
Shell/Bash
0 vote131 views1 answer
Ubonto change lang switch commad
Shell/Bash
0 vote122 views1 answer
Oracle docker images
Shell/Bash
0 vote118 views1 answer
Npm fibers windows error
Shell/Bash

Share