/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 vote145 views1 answer
Micro linux
Shell/Bash
0 vote146 views1 answer
Raspberry software installeren
Shell/Bash
0 vote165 views1 answer
Installing cdf
Shell/Bash
0 vote158 views1 answer
Powershell hidden window
Shell/Bash
2 votes190 views1 answer
Asyncstorage community
Shell/Bash
3 votes145 views2 answers
Mac restart mysql server
Shell/Bash
0 vote313 views1 answer
Allow users ssh
Shell/Bash
6 votes145 views4 answers
Docker start container
Shell/Bash
0 vote146 views1 answer
Git bisect
Shell/Bash
45 votes162 views6 answers
Git rm folder
Shell/Bash

Share