/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

10 votes153 views3 answers
Git clone --recurse-submodules
Shell/Bash
0 vote144 views1 answer
Download all branched on git clone
Shell/Bash
1 vote140 views1 answer
Vscode disable powershell integrated console
Shell/Bash
2 votes135 views1 answer
How to iterate through a file linux
Shell/Bash
0 vote151 views1 answer
How to calculate nearest location using longitude and latitude
Shell/Bash
1 vote140 views1 answer
Error: package android.support.v4.content does not exis
Shell/Bash
0 vote229 views1 answer
Git config --system core.longpaths true premission denied
Shell/Bash
0 vote141 views2 answers
A two digit month could not be found Data missing
Shell/Bash
2 votes145 views2 answers
Echo to file
Shell/Bash
9 votes142 views1 answer
Git amend no edit
Shell/Bash

Share