/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

38 votes185 views5 answers
How to install dotenv
Shell/Bash
0 vote244 views1 answer
What is remote repository
Shell/Bash
13 votes199 views1 answer
Sudo snap install slack –classic
Shell/Bash
1 vote219 views1 answer
Create private repository github command line
Shell/Bash
0 vote263 views2 answers
Read motd ubuntu
Shell/Bash
13 votes232 views3 answers
Bs4.FeatureNotFound: Couldn't find a tree builder with the features you requested: lxml. Do you need to install a parser library?
Shell/Bash
0 vote220 views1 answer
How do I add a commit to an existing pull request
Shell/Bash
0 vote282 views1 answer
Docker show currently running containers
Shell/Bash
2 votes223 views1 answer
Remove git credentials terminal
Shell/Bash
0 vote202 views1 answer
Git overwrite local branch with remote
Shell/Bash

Share