/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

1 vote262 views1 answer
Powershell unzip file
Shell/Bash
31 votes160 views2 answers
Check jdk version
Shell/Bash
0 vote201 views1 answer
The lsb_release command ubuntu faq
Shell/Bash
10 votes166 views1 answer
How to install specific package version npm
Shell/Bash
15 votes167 views1 answer
Sudo ufw status Status: inactive
Shell/Bash
2 votes167 views2 answers
Get diff stash
Shell/Bash
1 vote188 views1 answer
Bashrc termina,
Shell/Bash
0 vote198 views1 answer
Timeshift
Shell/Bash
12 votes167 views5 answers
Ifconfig not found
Shell/Bash
9 votes157 views4 answers
Change ubuntu username
Shell/Bash

Share