/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

18 votes297 views6 answers
Screen kill all
Shell/Bash
40 votes304 views5 answers
Install brew in mac
Shell/Bash
0 vote296 views1 answer
Git use cat instead of less
Shell/Bash
12 votes311 views3 answers
Obs for ubuntu
Shell/Bash
3 votes321 views6 answers
Set execution policy powershell
Shell/Bash
8 votes337 views5 answers
Sed remove line containing
Shell/Bash
0 vote297 views1 answer
Nuget Apache.Ignite
Shell/Bash
5 votes307 views2 answers
Docker run restart always
Shell/Bash
0 vote296 views1 answer
Mongo-sanitize github
Shell/Bash
1 vote289 views2 answers
Ubuntu software doesn't work 20.04
Shell/Bash

Share